Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6747E476043 for ; Mon, 11 Nov 2002 14:21:06 -0500 (EST) Received: from mail.troycable.net (unknown [66.21.97.117]) by postgresql.org (Postfix) with ESMTP id E1E66476069 for ; Mon, 11 Nov 2002 14:21:05 -0500 (EST) Received: (from root@localhost) by mail.troycable.net (8.12.3/8.12.3) id gABJRAR8020785 for pgsql-sql@postgresql.org; Mon, 11 Nov 2002 13:27:10 -0600 (CST) (envelope-from floyds@4peakstech.com) Received: from fig ([65.82.122.144]) by mail.troycable.net (8.12.3/8.11.6) with SMTP id gABJR8wZ020748 for ; Mon, 11 Nov 2002 13:27:08 -0600 (CST) (envelope-from floyds@4peakstech.com) From: floyds@4peakstech.com To: "Pgsql-Sql" Subject: parse bug Date: Mon, 11 Nov 2002 13:25:16 -0600 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/179 X-Sequence-Number: 10321 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; 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