Re: casting... adding integer to timestamp

Поиск
Список
Период
Сортировка
Искать
От
Michael Glaesemann
Тема
Re: casting... adding integer to timestamp
Дата
Msg-id
D2195042-5687-4B5F-87A2-B0E13B695EBA@seespotcode.net
Ответ на
Список
Дерево обсуждения
casting... adding integer to timestamp Mark Gibson <mark@gibsonsoftware.com>
Re: casting... adding integer to timestamp Alex Pavlovic <alex.pavlovic@taskforce-1.com>
Re: casting... adding integer to timestamp Frank Finner <postgresql@finner.de>
Re: casting... adding integer to timestamp Michael Glaesemann <grzm@seespotcode.net>
Re: casting... adding integer to timestamp Mark Gibson <mark@gibsonsoftware.com>

On Jun 25, 2006, at 14:23 , Mark Gibson wrote:

> SELECT  play_length - INTERVAL 'play_seconds seconds' ...

The column isn't interpolated into the string. Try

SELECT play_length - play_seconds * INTERVAL '1 second'

Hope this helps.

Michael Glaesemann
grzm seespotcode net



В списке pgsql-general по дате отправления
От: Mark Gibson
Дата:
От: Frank Finner
Дата:
FAQ