I have a problem with defining an array in pl/pgsql using an already defined column in a table. Is it possible to define an array ( v_var1 ) as in my example below:
If it is not possible now it would be really nice to have in a future release , maybe something for 8.4 wishlist ?
create table test1 ( test_id int not null, amount int not null, constraint pk_test_id primary key (test_id) );
create or replace function test1_func( t_id test1.test_id%TYPE ) returns int as $$ declare v_var1 test1.amount%TYPE[]; -- v_var1 int[]; v_var2 test1.amount%TYPE; begin v_var1[1] := 1; v_var2 := 1; return 1; end; $$ language plpgsql;
Best Regards DS
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.