Re: select DISTINCT not ordering the returned rows

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: select DISTINCT not ordering the returned rows
Дата
Msg-id ikmabt$fm7$1@dough.gmane.org
обсуждение исходный текст
Ответ на select DISTINCT not ordering the returned rows  (Ioana Danes <ioanasoftware@yahoo.ca>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: select DISTINCT not ordering the returned rows
Следующее
От: Ioana Danes
Дата:
Сообщение: Re: select DISTINCT not ordering the returned rows