arrays and polygons - Mailing list pgsql-sql

From David
Subject arrays and polygons
Date
Msg-id 001e01c3f21b$a8c0eb00$2d650c81@ad.kent.ac.uk
Whole thread Raw
Responses Re: arrays and polygons
List pgsql-sql
Hi there i am having problems inserting an array of polygons into a table, i
have added the column using:

ALTER TABLE species ADD COLUMN location polygon[];

this works fine, but when i try

INSERT INTO species (location) VALUES ('{((432,89), (45,87), (89,87)),
((54,78), (34,98))};

I get the following error message:

ERROR: Bad polygon external representation '((432'

Where am i going wrong, all help is much appreciated DAvid



pgsql-sql by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: How to avoid nulls while writing string for dynamic query
Next
From: Tomasz Myrta
Date:
Subject: column alias and group by/having/order