Inserting into point[] type.

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

Предыдущее
От: Stef
Дата:
Сообщение: Maybe install debian on your home pc?
Следующее
От: Stef
Дата:
Сообщение: Re: Maybe install debian on your home pc?