Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 01674477834 for ; Wed, 13 Mar 2002 11:04:43 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id C5521D5F7; Wed, 13 Mar 2002 08:04:47 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id BAD685BFD; Wed, 13 Mar 2002 08:04:47 -0800 (PST) Date: Wed, 13 Mar 2002 08:04:47 -0800 (PST) From: Stephan Szabo To: Cc: Subject: Re: subquery involving 'now' In-Reply-To: <79746497.63E9E835.00014635@cs.com> Message-ID: <20020313080353.S81426-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200203/154 X-Sequence-Number: 7034 On Thu, 7 Mar 2002 jmycr@cs.com 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; > > this does not work, any suggestions Maybe - ((select maxday_savefile from service) || ' days')::timespan