Received: from imo-r09.mx.aol.com (imo-r09.mx.aol.com [152.163.225.105]) by postgresql.org (Postfix) with ESMTP id BD41D47586C for ; Fri, 8 Mar 2002 09:13:35 -0500 (EST) Received: from JMYCR@cs.com by imo-r09.mx.aol.com (mail_out_v32.5.) id k.fe.14b795b3 (16099) for ; Fri, 8 Mar 2002 09:13:31 -0500 (EST) Received: from netscape.com (mow-m03.webmail.aol.com [64.12.184.131]) by air-id11.mx.aol.com (v83.35) with ESMTP id MAILINID113-0308091331; Fri, 08 Mar 2002 09:13:31 -0500 Date: Fri, 08 Mar 2002 09:13:31 -0500 From: jmycr@cs.com To: pgsql-sql@postgresql.org Subject: 'now' problem Message-ID: <6E780245.25FCD282.00014635@cs.com> X-Mailer: Atlas Mailer 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Archive-Number: 200203/147 X-Sequence-Number: 7027 SELECT a.id, a.archive_id, a.bk_name, b.ip FROM archive a, backup b WHERE a.file_status = 0 and a.bkup_name = b.bkup_name and a.backup_date < 'now'::datetime - '(SELECT s.maxday_savefile FROM backupservice s WHERE info.service_type = s.service and a.backup_id = info.backup_id) days'::timespan;