Rakotomandimby Mihamina <mihamina(at)gulfsat(dot)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