Re: Create interval using column value?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Create interval using column value?
Дата
Msg-id 9636.1098673912@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Create interval using column value?  (Larry Lennhoff <llennhoff-postgres@pexicom.com>)
Ответы Re: Create interval using column value?  (Larry Lennhoff <llennhoff-postgres@pexicom.com>)
Список pgsql-sql
Larry Lennhoff <llennhoff-postgres@pexicom.com> writes:
> 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';

You are confused about the difference between a literal constant and an
expression.   Try something like

... WHERE built_on < now() - build_interval * interval '1 second';

which relies on the number-times-interval operator.
        regards, tom lane


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

Предыдущее
От: Larry Lennhoff
Дата:
Сообщение: Create interval using column value?
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: Create interval using column value?