interval syntax change from 7.1.2 to 7.2.1?

Поиск
Список
Период
Сортировка
От Jinn Koriech
Тема interval syntax change from 7.1.2 to 7.2.1?
Дата
Msg-id 1027356574.1144.9.camel@morph.magiclamp.2y.net
обсуждение исходный текст
Список pgsql-sql
hi - i recently upgraded my server from 7.1.2 to 7.2.1 and now one of my
apps is no longer functioning.  this is the query:

SELECT DISTINCT rate, sum(extract(epoch from interval (end_time -
start_time)))/3600) AS durationFROM logWHERE invoice_state='8'GROUP BY rate HAVING rate > 0

where 'end_time' and 'start_time' are columns in table 'log'

the reported message is:

PostgreSQL said: ERROR: parser: parse error at or near "end_time"

any help greatly appreciated.

jinn


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

Предыдущее
От: "Gaetano Mendola"
Дата:
Сообщение: Re: interval syntax change from 7.1.2 to 7.2.1?
Следующее
От: James Orr
Дата:
Сообщение: Re: Editor for pgsql