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

From Theo Galanakis
Subject Inserting into point[] type.
Date
Msg-id 82E30406384FFB44AFD1012BAB230B55037D0500@shiva.au.lpint.net
Whole thread Raw
Responses Re: Inserting into point[] type.  (Markus Bertheau <twanger@bluetwanger.de>)
List pgsql-sql
<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> 

pgsql-sql by date:

Previous
From: Stef
Date:
Subject: Maybe install debian on your home pc?
Next
From: Stef
Date:
Subject: Re: Maybe install debian on your home pc?