Received: from mail.xnet.com (quake.xnet.com [198.147.221.67]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA32913 for ; Sat, 11 Dec 1999 19:41:52 -0500 (EST) (envelope-from selkovjr@selkovjr.xnet.com) Received: from selkovjr.xnet.com ([204.248.57.203]) by mail.xnet.com (8.9.3+Sun/XNet-3.0R) with ESMTP id SAA11940; Sat, 11 Dec 1999 18:41:50 -0600 (CST) Message-Id: <199912120041.SAA11940@mail.xnet.com> To: Brent Wood cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] polygon problem In-Reply-To: Your message of "Sun, 12 Dec 1999 10:32:44 +1300." <3852C2FC.BF4B14A7@blazemail.com> Date: Sat, 11 Dec 1999 19:43:26 -0600 From: "Gene Selkov Jr." According to Brent Wood: > > insert into table1 values ('poly1',((0,0),(0,1),(1,0)),'s'); > This fails with the msg: > ERROR: parser: parser error at or near "," > > As I read the docs on polygon types, this should work. It shouldn't. The SQL parser can't read the VALUES() clause because you omitted the quotes around the polygon string. It had to be: insert into table1 values ('poly1', '((0,0),(0,1),(1,0))', 's'); or insert into table1 values ('poly1', '(0,0,0,1,1,0)', 's'); --Gene