Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Дата
Msg-id CAKFQuwbye-t24D59BUR05YyUtuaiFgCQWHMVq6qcz0axsKrT=A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.  ("Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>)
Ответы Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.  ("Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>)
Список pgsql-sql
Дерево обсуждения
On Monday, February 8, 2016, Venkatesan, Sekhar <sekhar.venkatesan@emc.com> wrote:

So from what I understand, you say in postgres, if the sort order is not specified, postgres returns results in any order. Am I right?

Yes.  It will optimize for speed without any regard for maintaining any kind of ordering.  You may get the desired order for various reasons but without ORDER BY you cannot be guaranteed.

David J. 

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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Следующее
От: "Venkatesan, Sekhar"
Дата:
Сообщение: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.