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

From: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
To: Rado Petrik <r(dot)p(at)szm(dot)sk>
Cc: PostgreSQL-mailinglist <pgsql-sql(at)postgresql(dot)org>
Subject: Re: ERROR:   pg_atoi: error in "NULL": can't
Date: 2003-05-07 15:47:01
Message-ID: 3EB92A75.E3335D8F@nsd.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(dot)p(at)szm(dot)sk>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2003-05-07 15:52:36 Re: Date Anomaly??
Previous Message scott.marlowe 2003-05-07 15:42:27 Re: An unresolved performance problem.