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(at)exchange(dot)webmd(dot)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