Re:

[Kevin Grittner]

Sergey Gigoyan <sergey....@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


--
Sent via pgsql-novice mailing list (pgsql-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice