Re: Stuck with a query...

From: Geoff Caplan <geoff(at)variosoft(dot)com>
To: pgsql-general-owner(at)postgresql(dot)org, Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Stuck with a query...
Date: 2005-03-08 18:53:43
Message-ID: 042244774.20050308185343@variosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg,

GS> There's no efficient way to write this in standard SQL.
GS> However Postgres has an extension DISTINCT ON that would
GS> do it:

Works as advertised - many thanks! I'd missed the DISTINCT
ON extension...

This really is a great list - you've saved me a couple of
hours of agony, I suspect.

------------------
Geoff Caplan
Vario Software Ltd
(+44) 121-515 1154

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ntinos 2005-03-08 19:12:24 SRF, JDBC and result info
Previous Message Greg Stark 2005-03-08 18:04:34 Re: Stuck with a query...