Re: [GENERAL] Function to ADD a value into each column of real[]

2007-07-13 Thread Jim Nasby
On Jul 10, 2007, at 2:38 PM, orehon wrote: Hello, if I have this table: CREATE TABLE teste ( id integer, picos real[], ); and insert this values: INSERT INTO teste VALUES(1, '{{1,2,3},{1,2,3},{1,2,3},{1,2,3}, {1,2,3}}'); INSERT INTO teste VALUES(2, '{{1,2,3},{1,2,3},{1,2,3},{1,2,3},{1,2,

[GENERAL] Function to ADD a value into each column of real[]

2007-07-12 Thread orehon
Hello, if I have this table: CREATE TABLE teste ( id integer, picos real[], ); and insert this values: INSERT INTO teste VALUES(1, '{{1,2,3},{1,2,3},{1,2,3},{1,2,3}, {1,2,3}}'); INSERT INTO teste VALUES(2, '{{1,2,3},{1,2,3},{1,2,3},{1,2,3},{1,2,3}, {1,2,3},{1,2,3}}'); INSERT INTO teste VAL