Re: Date comparison question

"Jan Bodey" <jan_bodey@hotmail.com> writes:
> SELECT * FROM utable
> WHERE now() - utimestamp > interval '10 hours';

> The problem I am having is that the interval is not fixed, and I would like 
> to be able to store it as a value in a database table.  The unit of the 
> interval can, however, be fixed, and will almost certainly be fixed to 
> hours.

Do you not want to store the values as type interval?  That would seem
like the most straightforward answer.  If you really want to store them
as plain numbers, there's a float-times-interval operator, so you could
do something like... > table.float8col * interval '1 hour';
        regards, tom lane