Re: ERROR: invalid input syntax for integer: "" - Mailing list pgsql-general

Rakotomandimby Mihamina <mihamina@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::TIMESTAMPWITH TIME ZONE   - '0'::INTERVAL)))::BIGINT ELSE '' END, 

FWIW, 8.4 will give you a syntax error pointer in cases like this.

            regards, tom lane