From: Markus Bertheau <twanger@bluetwanger.de>
To: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: Inserting into point[] type.
Date: Thu, 12 Aug 2004 10:27:28 +0200
Message-ID: <1092299247.2620.1.camel@dicaprio.akademie1.de> (raw)
In-Reply-To: <82E30406384FFB44AFD1012BAB230B55037D0500@shiva.au.lpint.net>
References: <82E30406384FFB44AFD1012BAB230B55037D0500@shiva.au.lpint.net>
В Чтв, 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>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: twanger@bluetwanger.de, Theo.Galanakis@lonelyplanet.com.au
Subject: Re: Inserting into point[] type.
In-Reply-To: <1092299247.2620.1.camel@dicaprio.akademie1.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox