Re: Fixing DISTINCT ON for duplicate keys

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

On Thu, Jul 31, 2008 at 01:38:37PM -0400, Tom Lane wrote:
> I looked into this trouble report:
> http://archives.postgresql.org/pgsql-sql/2008-07/msg00123.php
>
> Comments?

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?

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Henry B. Hotz 2008-07-31 18:14:29 Re: Plans for 8.4
Previous Message claudio lezcano 2008-07-31 17:52:45 compilig libpq with borland 5.5