| 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: | Whole Thread | Raw Message | 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
| 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 |