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)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
