Rakotomandimby Mihamina <miham...@gulfsat.mg> writes:
> I get invalid input syntax when UPDATEing my radacct table:
It's the ELSE '' here:
> AcctSessionTime = CASE WHEN '' = '' THEN (EXTRACT(EPOCH FROM
> ('2009-09-25 10:35:44'::TIMESTAMP WITH TIME ZONE - AcctStartTime::TIMESTAMP
> WITH TIME ZONE - '0'::INTERVAL)))::BIGINT ELSE '' END,
FWIW, 8.4 will give you a syntax error pointer in cases like this.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
