On Oct 25, 2004, at 11:54 AM, Larry Lennhoff wrote:
> SELECT A.id FROM A JOIN B ON (join_col) WHERE built_on < now() -
> interval 'build_interval seconds';
It would help to see the error you're getting, but I suspect it has
something to do with the fact that you're quoting 'build_interval'. Try
something like WHERE built_on < current_timestamp - build_interval *
INTERVAL '0.001 second';
(btw, current_timestamp is the SQL standard for now() )
Regards,
Michael Glaesemann
grzm myrealbox com