arrays and polygons

From: "David" <de4(at)kent(dot)ac(dot)uk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: arrays and polygons
Date: 2004-02-13 10:25:10
Message-ID: 001e01c3f21b$a8c0eb00$2d650c81@ad.kent.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2004-02-13 13:34:54 column alias and group by/having/order
Previous Message Tomasz Myrta 2004-02-13 09:28:20 Re: How to avoid nulls while writing string for dynamic query