Re: ERROR: invalid input syntax for integer: ""

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rakotomandimby Mihamina <mihamina(at)gulfsat(dot)mg>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: invalid input syntax for integer: ""
Date: 2009-09-25 14:12:22
Message-ID: 19541.1253887942@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2009-09-25 14:25:46 Re: repeatedly process termination in PG 8.2
Previous Message Luiz Bernardi 2009-09-25 13:47:30 close inactive client connection