Re: Fixing DISTINCT ON for duplicate keys

On Thu, Jul 31, 2008 at 03:10:35PM -0400, Tom Lane wrote:
> David Fetter <david@fetter.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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

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