Re: 7.3.4 and 7.4 ORDER in queries

javier garcia - CEBAS <rn001@cebas.csic.es> writes:

> Hi,
> I'm not an expert, not by far.
> I've just installed postgres7.4 and have realized tat the order of rows in
> queries in different to that in 7.3.4. It seems that previously it was more
> logic, ordering by the first column, then by the second,... by default.
> At least this is so in a couple of queries I have. And now I have to
> explicitly say the order I want.
>
> Could someone just tell me why is this so?

Unless you specify ORDER BY, the order of matching rows returned by a
query is completely up to the server.  So it's not suprising that the
ordering changed.

If you depend on order, always use ORDER BY.

-Doug