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