Re: Inserting into point[] type. - Mailing list pgsql-sql

From Markus Bertheau
Subject Re: Inserting into point[] type.
Date
Msg-id 1092299247.2620.1.camel@dicaprio.akademie1.de
Whole thread Raw
In response to Inserting into point[] type.  (Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>)
List pgsql-sql
В Чтв, 12.08.2004, в 09:58, Theo Galanakis пишет:
> How do you insert into a column of type point[]

> I have tried without success:
>
> insert into test (Column_a, Column_b) values
> ('Aargau','{47.3899993896,8.03400039673}')

I'd guess '{(3.3, 4.4), (1.0, 4.3)}' or ARRAY[(3.3, 4.4), (1.0, 4.3)].
Maybe even something like '{''(3.3, 4.4)'', ''(1.0, 4.3)''}'

--
Markus Bertheau <twanger@bluetwanger.de>




pgsql-sql by date:

Previous
From: Stef
Date:
Subject: Re: Maybe install debian on your home pc?
Next
From: Devin Whalen
Date:
Subject: Sending errors from psql to error file