Re: Grouping by date range - Mailing list pgsql-general

From Ron Johnson
Subject Re: Grouping by date range
Date
Msg-id 1061406179.29044.12.camel@haggis
Whole thread Raw
In response to Re: Grouping by date range  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: Grouping by date range  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
On Wed, 2003-08-20 at 13:58, Bruno Wolff III wrote:
> On Wed, Aug 20, 2003 at 13:44:59 -0500,
>   Ron Johnson <ron.l.johnson@cox.net> wrote:
> >
> > The GROUP BY does implicit sorting, so an ORDER BY on the exact same
> > column(s) as the GROUP BY is redundant.
>
> That is an implementation detail, not a promise. With hashed aggregates
> in 7.4, you might find this isn't true.

Now that's interesting.  I'd have gone to my grave thinking it was
part of the spec...

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

"As I like to joke, I may have invented it, but Microsoft made
it popular"
David Bradley, regarding Ctrl-Alt-Del


pgsql-general by date:

Previous
From: yacht@seznam.cz
Date:
Subject: FK to inherited table, referential integrity violation
Next
From: Jean-Luc Lachance
Date:
Subject: Re: Mailing list in French