From: | Erik Wasser <erik(dot)wasser(at)iquer(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Howto turn an integer into an interval? |
Date: | 2004-10-05 12:07:41 |
Message-ID: | 200410051407.42037.erik.wasser@iquer.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi List,
I got a table named foobar with two fields
last_sms is a 'timestamp without timezone'
resend_interval is a 'integer'
I choose 'integer' for resend_interval rather than a 'interval' because
the frontend can easier handle the number of seconds. But now I'm stuck
with the query to get all rows that we're older than 'resend_interval'
in seconds.
My first try was:
SELECT *
FROM sms_groups
WHERE
(current_timestamp - last_sms) > '3600 seconds'::interval
This is working great and returns all rows that are older than a hour.
But how I do this with the colum 'resend_interval' in the query?
SELECT *
FROM sms_groups
WHERE
(current_timestamp - last_sms) > resend_interval::interval
gives me only a "cannot cast type integer to interval". So how can I
turn an integer to an interval? Or is there an other solution?
Suggestions?
P.S: I'm using psql '7.4.5' of gentoo.
--
So long... Fuzz
From | Date | Subject | |
---|---|---|---|
Next Message | Pierre-Frédéric Caillaud | 2004-10-05 12:38:48 | Re: Howto turn an integer into an interval? |
Previous Message | Achilleus Mantzios | 2004-10-05 11:44:56 | Re: Howto turn an integer into an interval? |