On Sat, Jun 14, 2003 at 07:33:19PM +0200, Sven K?hler wrote: > > "select *" should refelect the cosmetical order of the columns.
Why? You asked for everything, and specified no order. > "select *" could be tranformed into something like "select col1, col2, > ..." according to the cosmetical order that's defined. What's wrong with CREATE VIEW if this is so important? A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <[EMAIL PROTECTED]> M2P 2A8 +1 416 646 3304 x110 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match