Re: [BUGS] We are not following the spec for HAVING without GROUP

Bruno Wolff III <bruno@wolff.to>

From: Bruno Wolff III <bruno@wolff.to>
To: Greg Stark <gsstark@mit.edu>
Cc: pgsql-hackers@postgresql.org
Date: 2005-03-14T04:56:55Z
Lists: pgsql-bugs, 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?