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

Поиск
Список
Период
Сортировка
От orehon
Тема Function to ADD a value into each column of real[]
Дата
Msg-id 1184096285.753327.167320@k79g2000hse.googlegroups.com
обсуждение исходный текст
Ответы Re: Function to ADD a value into each column of real[]
Список 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 по дате отправления: