"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