Re: [BUGS] We are not following the spec for HAVING without GROUP - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: [BUGS] We are not following the spec for HAVING without GROUP
Date
Msg-id 20050314045655.GC30090@wolff.to
Whole thread Raw
In response to Re: [BUGS] We are not following the spec for HAVING without GROUP  (Greg Stark <gsstark@mit.edu>)
Responses Re: [BUGS] We are not following the spec for HAVING without GROUP
Re: [BUGS] We are not following the spec for HAVING without GROUP
List pgsql-hackers
On Sun, Mar 13, 2005 at 23:24:18 -0500, Greg Stark <gsstark@mit.edu> wrote:
> 
> I've noticed quite frequently scenarios where this idiom would be very handy.
> I usually either end up rewriting the query to have nested subqueries so I can
> push the grouping into the subquery. This doesn't always work though and
> sometimes I end up listing several, sometimes dozens, of columns like
> "first(x) AS x" or else end up

If someone did a naive implementation of first() and last() aggregates
for 8.1, is that something that would likely be accepted?


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: [BUGS] We are not following the spec for HAVING without GROUP
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] How to read query plan