X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6C2949DCAAC for ; Mon, 5 Dec 2005 06:56:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33197-07 for ; Mon, 5 Dec 2005 06:56:23 -0400 (AST) X-Greylist: delayed 00:12:38.976527 by SQLgrey- Received: from smtp2.anpe.fr (unknown [80.118.163.16]) by postgresql.org (Postfix) with ESMTP id E57889DCAA8 for ; Mon, 5 Dec 2005 06:56:19 -0400 (AST) Received: from homere03.anpe.fr (amadeus [127.0.0.1]) by smtp2.anpe.fr (antivirus) with ESMTP id 084D373C80 for ; Mon, 5 Dec 2005 11:43:39 +0100 (CET) Received: from HOMERE01.anpe.fr ([10.0.6.136]) by homere03.anpe.fr with Microsoft SMTPSVC(6.0.3790.1830); Mon, 5 Dec 2005 11:43:07 +0100 Received: from [10.0.32.170] ([10.0.32.170]) by HOMERE01.anpe.fr with Microsoft SMTPSVC(6.0.3790.1830); Mon, 5 Dec 2005 11:43:06 +0100 Message-ID: <439419CA.9060609@anpe.fr> Date: Mon, 05 Dec 2005 11:43:22 +0100 From: Patrick JACQUOT User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: PostgreSQL - SQL Subject: Re: Just 1 in a series... References: <43908131.9060403@noaa.gov> <3720.1133544030@sss.pgh.pa.us> <439087FB.8000003@noaa.gov> In-Reply-To: <439087FB.8000003@noaa.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 05 Dec 2005 10:43:06.0979 (UTC) FILETIME=[AD63BB30:01C5F988] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/23 X-Sequence-Number: 23565 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)