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?