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

From Rakotomandimby Mihamina
Subject ERROR: invalid input syntax for integer: ""
Date
Msg-id 4ABCA03C.1070307@gulfsat.mg
Whole thread Raw
Responses Re: ERROR: invalid input syntax for integer: ""
Re: ERROR: invalid input syntax for integer: ""
Re: ERROR: invalid input syntax for integer: ""
List pgsql-general
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 nextval('radacct_radacctid_seq'::regclass)
  acctsessionid        | character varying(32)    | not null
  acctuniqueid         | character varying(32)    | not null
  username             | character varying(253)   |
  groupname            | character varying(253)   |
  realm                | character varying(64)    |
  nasipaddress         | inet                     | not null
  nasportid            | character varying(15)    |
  nasporttype          | character varying(32)    |
  acctstarttime        | timestamp with time zone |
  acctstoptime         | timestamp with time zone |
  acctsessiontime      | bigint                   |
  acctauthentic        | character varying(32)    |
  connectinfo_start    | character varying(50)    |
  connectinfo_stop     | character varying(50)    |
  acctinputoctets      | bigint                   |
  acctoutputoctets     | bigint                   |
  calledstationid      | character varying(50)    |
  callingstationid     | character varying(50)    |
  acctterminatecause   | character varying(32)    |
  servicetype          | character varying(32)    |
  xascendsessionsvrkey | character varying(10)    |
  framedprotocol       | character varying(32)    |
  framedipaddress      | inet                     |
  acctstartdelay       | integer                  |
  acctstopdelay        | integer                  |
Indexes:
     "radacct_pkey" PRIMARY KEY, btree (radacctid)

The query is:


UPDATE radacct
  SET
   AcctStopTime = ('2009-09-25 10:35:44'::timestamp - '0'::interval),
   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, 
   AcctInputOctets = (('0'::bigint << 32) + '0'::bigint),
   AcctOutputOctets = (('0'::bigint << 32) + '0'::bigint),
   AcctTerminateCause = '',
   AcctStopDelay = 0,
   FramedIPAddress = NULLIF('', '')::inet,
   ConnectInfo_stop = ''
  WHERE AcctSessionId = ''
   AND UserName = 'mihamina'
   AND NASIPAddress = '0.0.0.0'
   AND AcctStopTime IS NULL




I cannot find the problem....
Any hints?
Thank you.

--
       Architecte Informatique chez Blueline/Gulfsat:
    Administration Systeme, Recherche & Developpement
                                    +261 34 29 155 34

pgsql-general by date:

Previous
From: S Arvind
Date:
Subject: Re: About logging
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: ERROR: invalid input syntax for integer: ""