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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Venkatesan, Sekhar" <sekhar(dot)venkatesan(at)emc(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Date: 2016-02-09 05:47:18
Message-ID: CAKFQuwbye-t24D59BUR05YyUtuaiFgCQWHMVq6qcz0axsKrT=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Monday, February 8, 2016, Venkatesan, Sekhar <sekhar(dot)venkatesan(at)emc(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Venkatesan, Sekhar 2016-02-09 05:48:32 Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Previous Message Rob Sargent 2016-02-09 05:33:43 Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.