Re: ERROR:  pg_atoi: error in "NULL": can't - Mailing list pgsql-sql

From Jean-Luc Lachance
Subject Re: ERROR:  pg_atoi: error in "NULL": can't
Date
Msg-id 3EB92A75.E3335D8F@nsd.ca
Whole thread Raw
In response to ERROR:  pg_atoi: error in "NULL": can't parse "NULL"  (Rado Petrik <r.p@szm.sk>)
List 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



pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Date Anomaly??
Next
From: Stephan Szabo
Date:
Subject: Re: Date Anomaly??