| From: | "Dan Str" <strd911(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pgplsql and arrays |
| Date: | 2008-02-20 18:17:00 |
| Message-ID: | 7de955570802201017r5004305av8d3fd413d97ff7@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi List !
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kynn Jones | 2008-02-20 19:02:14 | Vacuous errors in pg_dump ... | pg_restore pipeline |
| Previous Message | intelforum | 2008-02-20 17:25:41 | Re: Using sequences in SQL text files |