Re: arrays and polygons

"David" <de4@kent.ac.uk> writes:
> ALTER TABLE species ADD COLUMN location polygon[];

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

I think you'd need to double-quote each polygon within the array
literal.
'{"((432,89), (45,87), (89,87))", "..."}'

The array parser doesn't think parens are special, so it's not going to
magically distinguish array commas from polygon commas for you.

BTW, if you are using 7.4, the ARRAY[] constructor syntax might be
easier to use.
        regards, tom lane