Received: from nts-03.mm.eutelsat.org (nts-03.mm.eutelsat.org [194.214.173.15]) by postgresql.org (Postfix) with ESMTP id 97561475F3F for ; Wed, 13 Mar 2002 11:58:14 -0500 (EST) Received: from dell-01.mm.eutelsat.org (IDENT:root@dell-01.mm.eutelsat.org [194.214.173.17]) by nts-03.mm.eutelsat.org (8.9.3/8.8.7) with ESMTP id RAA19213; Wed, 13 Mar 2002 17:56:34 +0100 Received: from GMENDOLA2 (gmendola2.mm.eutelsat.org [194.214.173.26]) by dell-01.mm.eutelsat.org (8.11.2/8.8.7) with SMTP id g2DGwIQ09147; Wed, 13 Mar 2002 17:58:19 +0100 Message-ID: <016501c1cab0$46eac390$d28efea9@GMENDOLA2> From: "Gaetano Mendola" To: , References: <79746497.63E9E835.00014635@cs.com> Subject: Re: subquery involving 'now' Date: Wed, 13 Mar 2002 17:58:19 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200203/150 X-Sequence-Number: 7030 wrote: > SELECT a.backup_id, a.archive_id, a.file_name, a.file_size, b.something > FROM archive a, burp b > WHERE a.aname = b.aname and a.backup_date < 'now'::datetime - '(select maxday_savefile from service) days'::timespan; Try: using now() not 'now'::datetime. Ciao.