Received: from morph.magiclamp.2y.net
	(host217-39-127-152.in-addr.btopenworld.com [217.39.127.152])
	by postgresql.org (Postfix) with ESMTP id C6EC3475B19
	for <pgsql-sql@postgresql.org>; Mon, 22 Jul 2002 12:58:41 -0400 (EDT)
Received: (from jinn@localhost)
	by morph.magiclamp.2y.net (8.11.6/8.11.6) id g6MGwli01488;
	Mon, 22 Jul 2002 17:58:47 +0100
Subject: interval syntax change from 7.1.2 to 7.2.1?
From: Jinn Koriech <lists@idealint.co.uk>
To: PostgreSQL Mailing List <pgsql-sql@postgresql.org>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 22 Jul 2002 17:58:47 +0100
Message-Id: <1027357127.1451.0.camel@morph.magiclamp.2y.net>
Mime-Version: 1.0
X-Archive-Number: 200207/334
X-Sequence-Number: 8712



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