Re: arrays and polygons - Mailing list pgsql-sql

From Joe Conway
Subject Re: arrays and polygons
Date
Msg-id 402CFC66.5060707@joeconway.com
Whole thread Raw
In response to Re: arrays and polygons  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tom Lane wrote:
> "David" <de4@kent.ac.uk> writes:
>>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.

FWIW, here's what it would look like in 7.4.x:

regression=# select ARRAY['((432,89), (45,87), (89,87))'::polygon, 
'((432,89), (45,87), (89,87))'];                            array
-------------------------------------------------------------
{"((432,89),(45,87),(89,87))","((432,89),(45,87),(89,87))"}
(1 row)

You need to explicitly cast at least the first polygon in order to get 
an array of polygons (versus an array of text).

HTH,

Joe


pgsql-sql by date:

Previous
From: "David"
Date:
Subject: Re: arrays and polygons
Next
From: "Jatinder Sangha"
Date:
Subject: Passing composite values to functions