Ð ÐÑÐ, 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.383896,8.03400039673}')
I'd guess '{(3.3, 4.4), (1.0, 4.3)}' or ARRAY[(3.3, 4.4), (1.0, 4.3)]
Title: Inserting into point[] type.
How do you insert into a column of type point[]
Sample table:
CREATE TABLE public.test
(
Column_a varchar(1000),
Column_b point[]
) WITHOUT OIDS;
I have tried without success:
insert into test (Column_a, Column_b) values ('Aargau','{47.38389
