Re: [SQL] Just 1 in a series...

[Mark Fenbers]

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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org