Re: Fixing DISTINCT ON for duplicate keys

On Thu, Jul 31, 2008 at 03:10:35PM -0400, Tom Lane wrote:
> David Fetter <david(at)fetter(dot)org> writes:
> > It seems to me that DISTINCT ON is just a special case of the more
> > general windowing functions
> > <http://archives.postgresql.org/pgsql-hackers/2008-07/msg01277.php>
> > Harada-san has been working on. Could these use the same
> > machinery?
>
> Perhaps at some point we could deprecate DISTINCT ON in favor of
> using windowing functions, but I'd not want to weigh down the
> windowing work with a mandate that it be bug-compatible with
> DISTINCT ON.

Good point. I was just thinking of going the other way, namely fixing
any misbehaviors of DISTINCT ON via machinery to be used by the
windowing functions. :)

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate