Postgres Pro
Downloads
Home   >   mailing lists

Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. - Mailing list pgsql-sql

From David G. Johnston
Subject Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Date
Msg-id CAKFQuwbye-t24D59BUR05YyUtuaiFgCQWHMVq6qcz0axsKrT=A@mail.gmail.com
Whole thread Raw
In response to Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.  ("Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>)
Responses Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
List pgsql-sql
Tree view
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 by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Next
From: "Venkatesan, Sekhar"
Date:
Subject: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.