Postgres Pro
Downloads
Home   >   mailing lists

Re: select DISTINCT not ordering the returned rows - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: select DISTINCT not ordering the returned rows
Date
Msg-id ikmabt$fm7$1@dough.gmane.org
Whole thread Raw
In response to select DISTINCT not ordering the returned rows  (Ioana Danes <ioanasoftware@yahoo.ca>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: select DISTINCT not ordering the returned rows
Next
From: Ioana Danes
Date:
Subject: Re: select DISTINCT not ordering the returned rows