X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 15116476479
	for <pgsql-sql@postgresql.org>; Wed,  7 May 2003 11:46:08 -0400 (EDT)
Received: from beamish.nsd.ca (beamish.nsd.ca [205.150.156.194])
	by postgresql.org (Postfix) with ESMTP id 28AD0476460
	for <pgsql-sql@postgresql.org>; Wed,  7 May 2003 11:46:07 -0400 (EDT)
Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id LAA26381;
	Wed, 7 May 2003 11:46:10 -0400
X-Authentication-Warning: beamish.nsd.ca: smap set sender to <jllachan@nsd.ca>
	using -f
Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap
	(V2.1/2.1+anti-relay+anti-spam)
	id xma026376; Wed, 7 May 03 11:45:55 -0400
Received: from nsd.ca (jllachan-linux.nsd.ca [192.168.101.148])
	by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id LAA01483;
	Wed, 7 May 2003 11:39:32 -0400
Message-ID: <3EB92A75.E3335D8F@nsd.ca>
Date: Wed, 07 May 2003 11:47:01 -0400
From: Jean-Luc Lachance <jllachan@nsd.ca>
X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.18-24.7.x i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Rado Petrik <r.p@szm.sk>
Cc: PostgreSQL-mailinglist <pgsql-sql@postgresql.org>
Subject: Re: ERROR:=?iso-8859-1?Q?=C2=A0?= pg_atoi: error in "NULL": can't 
References: <1052319447.555.102.camel@caj>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Spam-Status: No, hits=-30.7 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,QUOTED_EMAIL_TEXT,REFERENCES,
	REPLY_WITH_QUOTES,X_AUTH_WARNING autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200305/130
X-Sequence-Number: 13295

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