Re: Just 1 in a series... - Mailing list pgsql-sql

From Mark Fenbers
Subject Re: Just 1 in a series...
Date
Msg-id 439087FB.8000003@noaa.gov
Whole thread Raw
In response to Re: Just 1 in a series...  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Just 1 in a series...  (Patrick JACQUOT <patrick.jacquot@anpe.fr>)
List 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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Just 1 in a series...
Next
From: george young
Date:
Subject: rename idx's with table; avoid confusing idx names?