Function to ADD a value into each column of real[] - Mailing list pgsql-general

From orehon
Subject Function to ADD a value into each column of real[]
Date
Msg-id 1184096285.753327.167320@k79g2000hse.googlegroups.com
Whole thread Raw
Responses Re: Function to ADD a value into each column of real[]  (Jim Nasby <decibel@decibel.org>)
List pgsql-general
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 VALUES(3, '{{1,2,3},{1,2,3},{1,2,3},{1,2,3},{1,2,3},
{1,2,3},{1,2,3},{1,2,3}}');
INSERT INTO teste VALUES(4, '{{1,2,3},{1,2,3},{1,2,3}}');

I need to write a function to return all the record of this table and
add a 0 in the begin of each array.
Ex.:

1, {{0,1,2,3},{0,1,2,3},{0,1,2,3},{0,1,2,3},{0,1,2,3}}
.............

How can I do that?
Any idea?!


pgsql-general by date:

Previous
From: Nik
Date:
Subject: Limit connections per username
Next
From: "Narasimha Rao P.A"
Date:
Subject: doubt