Postgres Pro
Downloads
Home   >   mailing lists

Re: How to handle a group query - Mailing list pgsql-novice

From Nigel Metheringham
Subject Re: How to handle a group query
Date
Msg-id 1099654369.2642.5.camel@angua.localnet
Whole thread Raw
In response to Re: How to handle a group query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
On Thu, 2004-11-04 at 14:15 -0500, Tom Lane wrote:
> If you don't mind using a Postgres-specific construct, SELECT DISTINCT ON
> works nicely for this.  See the "weather reports" example in the SELECT
> reference page.

It took a few minutes for what you were suggesting to click, but now I
am completely blown away by that - its *so* much simpler.

Cheers
    Nigel.
--
[ Nigel Metheringham           Nigel.Metheringham@InTechnology.co.uk ]
[ - Comments in this message are my own and not ITO opinion/policy - ]

pgsql-novice by date:

Previous
From: Terry Lee Tucker
Date:
Subject: Re: Question on locking
Next
From: Kjetil Haaland
Date:
Subject: varchar in c extension function