Sergey Gigoyan <sergey.gigoyan@gmail.com> wrote:
> I have function with character varying array as input parameter.
> example
> get_list(IN session_id integer,IN parameters_list character varying[])
>
> How can I call this function (pass array elements to function)?
test=# create or replace function get_list(IN session_id integer,IN parameters_list character varying[])
test-# returns setof varchar
test-# language SQL
test-# as $$
test$# select unnest($2);
test$# $$;
CREATE FUNCTION
test=# select get_list(1, array['asdf','qwerty']);
get_list
----------
asdf
qwerty
(2 rows)
http://www.postgresql.org/docs/9.2/interactive/arrays.html
-Kevin