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

In response to Rakotomandimby Mihamina :
> Hi all,
> I get invalid input syntax when UPDATEing my radacct table:
>
> freedsl=# \d radacct
>                                             Table "public.radacct"
>         Column        |           Type           |
>         Modifiers
> ----------------------+--------------------------+-------------------------------------------------------------
>  radacctid            | bigint                   | not null default
> ...
>  acctsessiontime      | bigint                   |
> ...
>   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,

test=*# select ''::int;
ERROR:  invalid input syntax for integer: ""


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)