Received: from imo-r01.mx.aol.com (imo-r01.mx.aol.com [152.163.225.97]) by postgresql.org (Postfix) with ESMTP id E13F4476780 for ; Thu, 7 Mar 2002 09:08:39 -0500 (EST) Received: from JMYCR@cs.com by imo-r01.mx.aol.com (mail_out_v32.5.) id k.112.db2cd05 (15814) for ; Thu, 7 Mar 2002 09:08:27 -0500 (EST) Received: from netscape.com (mow-m03.webmail.aol.com [64.12.184.131]) by air-id05.mx.aol.com (v83.35) with ESMTP id MAILINID57-0307090826; Thu, 07 Mar 2002 09:08:26 -0500 Date: Thu, 07 Mar 2002 09:08:26 -0500 From: jmycr@cs.com To: pgsql-sql@postgresql.org Subject: subquery involving 'now' Message-ID: <79746497.63E9E835.00014635@cs.com> X-Mailer: Atlas Mailer 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Archive-Number: 200203/140 X-Sequence-Number: 7020 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; this does not work, any suggestions jnc