Re: Inserting into point[] type.

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Theo Galanakis <Theo(dot)Galanakis(at)lonelyplanet(dot)com(dot)au>
Cc: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Inserting into point[] type.
Date: 2004-08-12 08:27:28
Message-ID: 1092299247.2620.1.camel@dicaprio.akademie1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bluetwanger(dot)de>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Hurst 2004-08-12 09:04:49 Returning A Varchar From A Function
Previous Message Stef 2004-08-12 08:01:09 Re: Maybe install debian on your home pc?