Thread: ERROR:  pg_atoi: error in "NULL": can't parse "NULL"

Hi , 


I have any column. 'test' . When I insert 'none' to column 'test' , no
problem.

test
-----
NONE 

But when I update column , postgreSQL return this error.
ERROR:  pg_atoi: error in "NULL": can't parse "NULL"

Where is problem ? 

Thanks
-- 
Rado Petrik <r.p@szm.sk>

Rado,

> But when I update column , postgreSQL return this error.
>
> ERROR:  pg_atoi: error in "NULL": can't parse "NULL"
>
> Where is problem ?

Please post your updated statement.

--
Josh Berkus
Aglio Database Solutions
San Francisco

Use NULL without quotes


Rado Petrik wrote:
>
> Hi ,
>
> I have any column. 'test' . When I insert 'none' to column 'test' , no
> problem.
>
> test
> -----
> NONE
>
> But when I update column , postgreSQL return this error.
>
> ERROR:  pg_atoi: error in "NULL": can't parse "NULL"
>
> Where is problem ?
>
> Thanks
> --
> Rado Petrik <r.p@szm.sk>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html