On Thu, Jul 31, 2008 at 03:10:35PM -0400, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
