No: implied sort with group by

From: Zeugswetter Andreas DBT <Andreas(dot)Zeugswetter(at)telecom(dot)at>
To: "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org>
Subject: No: implied sort with group by
Date: 1998-01-27 10:13:24
Message-ID: 219F68D65015D011A8E000006F8590C6010A51AD@sdexcsrv1.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message James Hughes 1998-01-27 11:14:14 Re: [HACKERS] postmaster crash and .s.pgsql file
Previous Message Goran Thyni 1998-01-27 10:08:33 Re: [HACKERS] Snapshot 270198 compile error