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