On 8/24/07, Robert Treat <xzilla@xxxxxxxxxxxxxxxxxxxxx> wrote: > On Friday 24 August 2007 17:18, Matthew wrote: > > Hey Bill, > > > > > It does not. > > > > Bummer. > > > > > To get your columns in a specific order, specify the column names in > > > that order in your SELECT statement. The SQL standard doesn't provide > > > for any other way to guarantee column order, and neither does Postgres. > > > > Yes, I realize this and we do identify our columns during select > > statements, but when you look at a table using a tool like phpPGAdmin or > > pgAdmin3, the columns are displayed in some defined order. It's much > > easier to see your data/columns in some logical order (ie: all the cost > > columns next to each other). > > > > FWIW (and it isnt much) we had the semblence of a patch and an actual plan for > implementing this, but no one got interested enough to finish it for 8.3. > Should you happen to know an ambituous C hacker, there is a good chance it > could be included in 8.4. > really? i don't remember it? can you point me where that patch is?, i can't find it, either -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly