Inserting into point[] type.
От | Theo Galanakis |
---|---|
Тема | Inserting into point[] type. |
Дата | |
Msg-id | 82E30406384FFB44AFD1012BAB230B55037D0500@shiva.au.lpint.net обсуждение исходный текст |
Ответы |
Re: Inserting into point[] type.
|
Список | 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 по дате отправления: