Re: [SQL] polygon problem

From: "Gene Selkov Jr(dot)" <selkovjr(at)selkovjr(dot)xnet(dot)com>
To: Brent Wood <brent(dot)wood(at)blazemail(dot)com>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] polygon problem
Date: 1999-12-12 01:43:26
Message-ID: 199912120041.SAA11940@mail.xnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-12-12 05:53:19 Re: [SQL] polygon problem
Previous Message Brent Wood 1999-12-11 21:32:44 polygon problem