Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group