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

From Patrick JACQUOT
Subject Re: Just 1 in a series...
Date
Msg-id 439419CA.9060609@anpe.fr
Whole thread Raw
In response to Re: Just 1 in a series...  (Mark Fenbers <Mark.Fenbers@noaa.gov>)
List pgsql-sql
Mark Fenbers wrote:

> 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
>
Maybe you could t'ry something like :
Select whatever  from  yourtable a where not exists(select * from yourtable b where b.id=a.id and b.timestamp >
a.timestamp)


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: How to get a count() where column < ''?
Next
From: Erik Sigra
Date:
Subject: Database query: Notification about change?