pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedinterval syntax change from 7.1.2 to 7.2.1?
3+ messages / 3 participants
[nested] [flat]
* interval syntax change from 7.1.2 to 7.2.1?
@ 2002-07-22 16:49 Jinn Koriech <jinn@idealint.co.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Jinn Koriech @ 2002-07-22 16:49 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* interval syntax change from 7.1.2 to 7.2.1?
@ 2002-07-22 16:58 Jinn Koriech <lists@idealint.co.uk>
0 siblings, 1 reply; 3+ messages in thread
From: Jinn Koriech @ 2002-07-22 16:58 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: interval syntax change from 7.1.2 to 7.2.1?
@ 2002-07-22 17:37 Gaetano Mendola <mendola@bigfoot.com>
parent: Jinn Koriech <lists@idealint.co.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Gaetano Mendola @ 2002-07-22 17:37 UTC (permalink / raw)
To: Jinn Koriech <lists@idealint.co.uk>; pgsql-sql
From: "Jinn Koriech" <lists@idealint.co.uk> wrote:
> 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.
>
Redo your query putting intervall beetwen " " :
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
Ciao
Gaetano.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-07-22 17:37 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-22 16:49 interval syntax change from 7.1.2 to 7.2.1? Jinn Koriech <jinn@idealint.co.uk>
2002-07-22 16:58 interval syntax change from 7.1.2 to 7.2.1? Jinn Koriech <lists@idealint.co.uk>
2002-07-22 17:37 ` Gaetano Mendola <mendola@bigfoot.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox