Обсуждение: inserting arrays from plpgsql.

Поиск
Список
Период
Сортировка

inserting arrays from plpgsql.

От
Bhuvan A
Дата:
Dear all,

i am trying to insert an array from a plpgsql function. But it didnt
work and i didnt know where i am wrong. hope to get some lights.

my need is something like this..

create table po
( comp_code text, po_no text, po_details text[]
);    
create table xx
( comp_code text, po_no text, po_line1 text, po_line2 text
);

and my function is..

create function ftest()
returns opaque as 'declare
 array_params po.po_details%type;

begin array_params := {new.po_line1, new.po_line2}; insert into po values (comp_code, po_no, params)
values(new.comp_code,new.po_no, array_params);
 

return new;
end;'
language 'plpgsql';

create trigger ttest after insert on xx for each row execute
procedure ftest();

----

my need is not exactly the same, but very similar.
Will be very happy, if I get some lights!         
Regards,
Bhuvaneswaran.