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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
