Array as parameter for plpgsql function
| От | David Pratt |
|---|---|
| Тема | Array as parameter for plpgsql function |
| Дата | |
| Msg-id | BFC56FCC-F395-11D9-97E3-000A27B3B070@eastlink.ca обсуждение исходный текст |
| Ответ на | 7.4.7: strange planner decision (Roman Neuhauser <neuhauser@sigpipe.cz>) |
| Ответы |
Re: Array as parameter for plpgsql function
|
| Список | pgsql-general |
How does one pass an array as a parameter to a plpgsql function? I
have tried this the following. I can't seem to get a select statement
to work without syntax problems and no examples in Postgres book to
help with this :( This is just a test so please ignore the fact it is
a simple function.
CREATE FUNCTION create_record_test(text[][]) RETURNS int4 AS '
DECLARE
test_array ALIAS FOR $1; -- alias for input array
BEGIN
return array_upper(test_array,1)
END;
' LANGUAGE 'plpgsql';
SELECT create_record_test(ARRAY[ARRAY['A','test one'],ARRAY['B','test
two']]) AS output;
В списке pgsql-general по дате отправления: