Обсуждение:

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)?

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