Thread: Inserting into point[] type.
<p><font face="Arial" size="2">How do you insert into a column of type point[] </font><p><font face="Arial"
size="2">Sampletable:</font><br /><font face="Arial" size="2">CREATE TABLE public.test</font><br /><font face="Arial"
size="2">(</font><br/><font face="Arial" size="2"> Column_a varchar(1000),</font><br /><font face="Arial" size="2">
Column_bpoint[]</font><br /><font face="Arial" size="2">) WITHOUT OIDS;</font><br /><p><font face="Arial" size="2">I
havetried without success:</font><p><font face="Arial" size="2">insert into test (Column_a, Column_b) values
('Aargau','{47.3899993896,8.03400039673}')</font><p><fontface="Arial" size="2">Theo</font><table><tr><td
bgcolor="#ffffff"><fontcolor="#000000">______________________________________________________________________<br />This
email,including attachments, is intended only for the addressee<br />and may be confidential, privileged and subject to
copyright.If you<br />have received this email in error, please advise the sender and delete<br />it. If you are not
theintended recipient of this email, you must not<br />use, copy or disclose its content to anyone. You must not copy
or<br />communicate to others content that is confidential or subject to <br />copyright, unless you have the consent
ofthe content owner.<br /></font></td></tr></table>
В Чтв, 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>