Re: Fixing DISTINCT ON for duplicate keys

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Fetter <david(at)fetter(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Fixing DISTINCT ON for duplicate keys
Date: 2008-07-31 19:10:35
Message-ID: 17623.1217531435@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kris Jurka 2008-07-31 19:45:13 Re: Should creating a new base type require superuser status?
Previous Message Tom Lane 2008-07-31 18:39:23 Re: Creating Universal OSX binaries