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

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.