Re: subtratcing dates

Thanks for the tip Tom!

At first, I accidentally tried to do reltime(limit*60) where limit was
accidentally an interval instead of an integer, and my database crashed
and exited horribly.  Perhaps that's why it's a poorly documented
function!  ;-)

-Fran

> Fran Fabrizio <ffabrizio@exchange.webmd.net> writes:
> > I want to have a query that tells me whether or not the timestamp is
> > within 'limit' minutes of the current time.
>
> A poorly documented fact is that you can coerce an integer number of
> seconds into a reltime, which can then be added to or subtracted from
> a timestamp.  So:
>
>         select tstamp > now() - reltime(limit*60) from ...
>
> should do it.
>
>                         regards, tom lane