Re: Just 1 in a series...

From: Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)gov>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Just 1 in a series...
Date: 2005-12-02 17:44:27
Message-ID: 439087FB.8000003@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
>
>You might find the "DISTINCT ON" syntax does just what you want --- see
>the "weather report" example on the SELECT reference page. It's not
>standard SQL though.
>
This works! Thanks!

What would have to be done if I needed a standard SQL solution?
Mark

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message george young 2005-12-02 18:00:37 rename idx's with table; avoid confusing idx names?
Previous Message Tom Lane 2005-12-02 17:20:30 Re: Just 1 in a series...