Stored function - send array as parameter to stored function

From: "hendra kusuma" <penguinroad(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Stored function - send array as parameter to stored function
Date: 2008-11-13 02:04:49
Message-ID: 26dadb3d0811121804l77d2b9aawdb346c3f6ec03823@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I'm new here
I've been doing a little self-learning about postgresql
and find it very interesting

I've been trying to create a stored procedure that receive array as
parameter and find a good and working example on the web

the code looks like this

create or replace function iterate(a int[])
returns void as $$
begin
for i in array_lower(a,1)..arry_upper(a,1) loop
raise notice '%', a[i];
end loop;
end;
$$ language plpgsql strict;

my problem is, how should I call this function?
I tried
select iterate(1,2)
select iterate([1,2])
select iterate({1,2})
none of them are working

how is it really to call this function

Thank you
Hendra

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2008-11-13 02:33:26 Re: Upgrading side by side in Gentoo
Previous Message Yi Zhao 2008-11-13 01:21:26 can someone help me to make a sql more pretty and more concise?