Search Postgresql Archives

Re: select DISTINCT not ordering the returned rows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ioana Danes, 02.03.2011 21:35:
Hi Everyone,

I would like to ask for your help finding a temporary solution for my problem.
I upgraded postgres from 8.3 to 9.0.3 and I have an issue with the order of the returned rows.


The database is free to return rows in any order it thinks is most efficient and you may never rely on any implicit ordering.

If you need your rows sorted in a specific way, you have to use an ORDER BY clause. Everything else is doomed to fail someday.

Regards
Thomas


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux