No: implied sort with group by - Mailing list pgsql-hackers

From Zeugswetter Andreas DBT
Subject No: implied sort with group by
Date
Msg-id 219F68D65015D011A8E000006F8590C6010A51AD@sdexcsrv1.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> Does the SQL standard say anything about an implied sort when
> grouping or is it up to the user to include an ORDER BY clause?
> darrenk

Without order by the result set is never guaranteed to be ordered in a
specific way (standard speak). The order is dependent on the chosen
query path, which
changes from query to query.

Andreas

pgsql-hackers by date:

Previous
From: Goran Thyni
Date:
Subject: Re: [HACKERS] Snapshot 270198 compile error
Next
From: James Hughes
Date:
Subject: Re: [HACKERS] postmaster crash and .s.pgsql file