interval syntax change from 7.1.2 to 7.2.1? - Mailing list pgsql-sql

From Jinn Koriech
Subject interval syntax change from 7.1.2 to 7.2.1?
Date
Msg-id 1027356574.1144.9.camel@morph.magiclamp.2y.net
Whole thread Raw
List 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 by date:

Previous
From: "Gaetano Mendola"
Date:
Subject: Re: interval syntax change from 7.1.2 to 7.2.1?
Next
From: James Orr
Date:
Subject: Re: Editor for pgsql