Postgres Pro
Downloads
Home   >   mailing lists

Re: Fixing DISTINCT ON for duplicate keys - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Fixing DISTINCT ON for duplicate keys
Date
Msg-id 17623.1217531435@sss.pgh.pa.us
Whole thread Raw
In response to Re: Fixing DISTINCT ON for duplicate keys  (David Fetter <david@fetter.org>)
Responses Re: Fixing DISTINCT ON for duplicate keys  (David Fetter <david@fetter.org>)
List pgsql-hackers
Tree view 
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.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Henry B. Hotz"
Date:
Subject: Re: Plans for 8.4
Next
From: Kris Jurka
Date:
Subject: Re: Should creating a new base type require superuser status?