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: [EMAIL PROTECTED] ICQ #: 161371538 acta non verba ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly