subquery involving 'now' - Mailing list pgsql-sql

From jmycr@cs.com
Subject subquery involving 'now'
Date
Msg-id 79746497.63E9E835.00014635@cs.com
Whole thread Raw
Responses Re: subquery involving 'now'  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Llew"
Date:
Subject: Re: where not exists
Next
From: Andre Schubert
Date:
Subject: REFERENCES