| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | javier garcia - CEBAS <rn001(at)cebas(dot)csic(dot)es> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 7.3.4 and 7.4 ORDER in queries |
| Date: | 2003-11-27 18:34:41 |
| Message-ID: | Pine.LNX.4.44.0311271933330.15144-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
javier garcia - CEBAS writes:
> 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.
Unless you specify ORDER BY explicitly, the order is completely random.
In practice, it depends on the order of the rows on disk and the query
execution plan, but those are implementation details that may change over
time. If you need a particular order, you need to say so.
--
Peter Eisentraut peter_e(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2003-11-27 19:39:56 | Re: 7.3.4 and 7.4 ORDER in queries |
| Previous Message | Doug McNaught | 2003-11-27 18:28:33 | Re: 7.3.4 and 7.4 ORDER in queries |