Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Date
Msg-id n9c1p7$nd$1@ger.gmane.org
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>)
List pgsql-sql
Tree view 
Venkatesan, Sekhar schrieb am 09.02.2016 um 06:21:
> 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?

This is nothing Postgres specific. This is true for *every* DBMS. 

Without an order by, the DBMS is free to return the rows in any order it wants.

If you have seen a specific order in SQL Server that was pure coincidence and can *not* be relied upon.

pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Next
From: "Mike Sofen"
Date:
Subject: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.