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 1027357127.1451.0.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 duration       FROM log       WHERE 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: ecitizen@hotmail.com (Ecitizen)
Date:
Subject: Free 4GL Compiler, Informix-Postgress support
Next
From: Jan Wieck
Date:
Subject: Re: Float / Numeric ?