Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruno Wolff III <bruno@wolff.to>
Cc: Greg Stark <gsstark@mit.edu>, pgsql-hackers@postgresql.org
Date: 2005-03-14T06:52:59Z
Lists: pgsql-bugs, pgsql-hackers 
Bruno Wolff III <bruno@wolff.to> writes:
> If someone did a naive implementation of first() and last() aggregates
> for 8.1, is that something that would likely be accepted?

For the purpose that Greg is suggesting, these would have no advantage
over min() or max() --- since the system wouldn't know how to optimize
them --- and they'd be considerably less standard.  So my inclination
would be to say it's a waste of effort.

			regards, tom lane