Create interval using column value?

Поиск
Список
Период
Сортировка
От Larry Lennhoff
Тема Create interval using column value?
Дата
Msg-id 6.0.2.0.0.20041024224504.03b5c7c8@localhost
обсуждение исходный текст
Ответы Re: Create interval using column value?
Re: Create interval using column value?
Список pgsql-sql
Hi

I have a table (A) with a integer column called build_interval, which 
contains the number of milliseconds betweeen builds.  I have another table 
(B) with a timestamp with timezone column called built_on.  The two tables 
share a column called join_col.  What I want to do is find all the rows in 
A which were built before now() - build_interval seconds ago.  If I could 
just write this in SQL it would look something like:

SELECT A.id FROM A JOIN B ON (join_col) WHERE built_on < now() - interval 
'build_interval seconds';  This does not work at all - I cannot find a way 
to build an interval using a column - casting an integer as an interval is 
forbidden. Can anyone suggest a way to achieve my desired result? I'm not 
wedded to the interval approach.  I can probably change the column type of 
build_interval if necessary.

I am using postgres 7.3.4

Thanks in advance for any help.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Markus Bertheau
Дата:
Сообщение: Re: Functions return a select in a table, which data type I
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Create interval using column value?