Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)gov> writes:
> ... However, I only want the first occurrence of a such a series (where the
> event_id is the same), what SQL syntax should I use to do this?
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.
regards, tom lane