Rakotomandimby Mihamina <mihamina@xxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
