Horton

Re: ERROR:   pg_atoi: error in "NULL": can't

Jean-Luc Lachance <jllachan@nsd.ca>

View thread View on postgr.es
From: Jean-Luc Lachance <jllachan@nsd.ca>
To: Rado Petrik <r.p@szm.sk>
Cc: PostgreSQL-mailinglist <pgsql-sql@postgresql.org>
Date: 2003-05-07T15:47:01Z
Lists: pgsql-sql 
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