Re: column order

Michael Glaesemann wrote:
>
> On May 24, 2006, at 11:54 , nuno wrote:
>
>> does postgresql guarantee you that
>> the columns in the result set would be ordered
>> as specified in the query (i.e. id, firstname, lastname, dob) ?
>
> No. If you want a specific order, use the ORDER BY clause.
I think the OP was talking about the order by the _columns_, not
the _rows_.

Postgres guarantees that order - Anything else would be simply insane.

greetings, Florian Pflug