From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Grouping by date range |
Date: | 2003-08-20 19:02:59 |
Message-ID: | 1061406179.29044.12.camel@haggis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)l(dot)johnson(at)cox(dot)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(dot)l(dot)johnson(at)cox(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-08-20 19:11:19 | Re: FK to inherited table, referential integrity violation |
Previous Message | yacht | 2003-08-20 18:58:33 | FK to inherited table, referential integrity violation |