Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5CEE5476417 for ; Tue, 12 Nov 2002 09:03:54 -0500 (EST) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id 119704763C3 for ; Tue, 12 Nov 2002 09:03:53 -0500 (EST) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id gACEA2B09315; Tue, 12 Nov 2002 16:10:02 +0200 Date: Tue, 12 Nov 2002 16:10:02 +0200 (EET) From: Achilleus Mantzios To: floyds@4peakstech.com Cc: Pgsql-Sql Subject: Re: parse bug In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/182 X-Sequence-Number: 10324 On Mon, 11 Nov 2002 floyds@4peakstech.com wrote: > > seems like an error in the sql parser to me: > > # create table test (acol smallint[]); > CREATE > # insert into test (acol) values ('{ 0 }'); > ERROR: pg_atoi: error in "0 ": can't parse " " > # insert into test (acol) values ('{ 0}'); > INSERT 28472 1 > > the only difference is the trailing " " after the 0; traditionally atoi ignores only leading spaces, so insert into test (acol) values ('{ 0}'); should work too. btw why do you need trailing spaces for?? > > > Regards, > > Floyd Shackelford > 4 Peaks Technology Group, Inc. > VOICE: 334.735.9428 > FAX: 916.404.7125 > EMAIL: FloydS@4PeaksTech.com > ICQ #: 161371538 > > acta non verba > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr