Re: [BUGS] We are not following the spec for HAVING without GROUP
От | Bruno Wolff III |
---|---|
Тема | Re: [BUGS] We are not following the spec for HAVING without GROUP |
Дата | |
Msg-id | 20050314072634.GA3860@wolff.to обсуждение исходный текст |
Ответ на | Re: [BUGS] We are not following the spec for HAVING without GROUP (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: [BUGS] We are not following the spec for HAVING without GROUP
|
Список | pgsql-hackers |
On Mon, Mar 14, 2005 at 01:52:59 -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote: > 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. The case I was thinking of were datatypes without a defined ordering where max and min wouldn't be usable. But if GROUP BY was going to changed to allow any columns if the primary key was used in the GROUP BY clause, I can't see any use for those functions.
В списке pgsql-hackers по дате отправления: