oceano <nathan(at)psphalifax(dot)ns(dot)ca> writes:
> I can't find any examples of using float arrays in a column.
regression=# create table foo(f1 float[]);
CREATE
regression=# insert into foo values ('{1,2.4,3.7,42}');
INSERT 1523558 1
regression=# select * from foo;
f1
------------------------
{"1","2.4","3.7","42"}
(1 row)
regression=# update foo set f1[3] = 99.99;
UPDATE 1
regression=# select * from foo;
f1
--------------------------
{"1","2.4","99.99","42"}
(1 row)
regression=#
regards, tom lane