At 05:00 PM 1/25/00 +1100, Philip Warner wrote:
>Out of curiosity, does the SQL spec give any rules or guidelines about when
>aggregates should be applied to resultant rows? Or is it one of the
Well...my copy of Date's now actually in the mail, rather than in
Boston, but at the moment that's not much help!
"order by" happens after everything, AFAIK. For instance...
orders the result of the union, which pretty much implies that
aggregates will happen first.
- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
In response to
pgsql-hackers by date
|Next:||From: Don Baccus||Date: 2000-01-25 15:53:53|
|Subject: Re: [HACKERS] Happy column dropping|
|Previous:||From: Hiroshi Inoue||Date: 2000-01-25 15:40:00|
|Subject: RE: [HACKERS] Sure enough, SI buffer overrun is broken|
pgsql-sql by date
|Next:||From: Palle Girgensohn||Date: 2000-01-25 16:03:05|
|Subject: Re: [SQL] Duplicate tuples with unique index|
|Previous:||From: Julian Scarfe||Date: 2000-01-25 13:23:58|
|Subject: Re: [SQL] DISTINCT ON: speak now or forever hold your peace|