Re: DISTINCT ... ORDER BY

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: DISTINCT ... ORDER BY
Дата
Msg-id 20031106022940.GA12926@wolff.to
обсуждение исходный текст
Ответ на Re: DISTINCT ... ORDER BY  (Nabil Sayegh <postgresql@e-trolley.de>)
Список pgsql-novice
On Wed, Nov 05, 2003 at 22:27:40 +0100,
  Nabil Sayegh <postgresql@e-trolley.de> wrote:
> Bruno Wolff III wrote:
> >On Wed, Nov 05, 2003 at 21:06:30 +0100,
> >  Nabil Sayegh <postgresql@e-trolley.de> wrote:
> >
> >>Ok, let's look for alternatives.
> >
> >
> >Did you try my corrected suggestion?
>
> Yes, and it worked, thanks.
> But then I was too afraid of it being non-deterministic :(
>
> Is this query deterministic?

You will always get the same output order for a table with a given set of
rows in it.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: DISTINCT ... ORDER BY
Следующее
От: "Robert C. Mosher II"
Дата:
Сообщение: Giving a user a database