pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: floyds@4peakstech.com
To: Pgsql-Sql <pgsql-sql@postgresql.org>
Subject: parse bug
Date: Mon, 11 Nov 2002 13:25:16 -0600
Message-ID: <NDBBKEGJICMIMJHJEBCOGEJEFMAA.floyds@4peakstech.com> (raw)


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





view thread (2+ messages)  latest in thread

Message-ID: <NDBBKEGJICMIMJHJEBCOGEJEFMAA.floyds@4peakstech.com>
Permalink:  ../NDBBKEGJICMIMJHJEBCOGEJEFMAA.floyds@4peakstech.com/
Also on:    postgresql.org/message-id/NDBBKEGJICMIMJHJEBCOGEJEFMAA.floyds@4peakstech.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: floyds@4peakstech.com
  Subject: Re: parse bug
  In-Reply-To: <NDBBKEGJICMIMJHJEBCOGEJEFMAA.floyds@4peakstech.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox