Re: passing array as argument and returning an array in - Mailing list pgsql-general

hello

It is possible

CREATE OR REPLACE FUNCTION foo(anyarray) RETURNS anyarray AS '
DECLARE b integer[];
BEGIN b := $1; b[1] := b[1] + 1;
  RETURN b;
END;
' LANGUAGE plpgsql;

testdb011=> select foo(ARRAY[1,2,3]);
   foo
---------
 {2,2,3}
(1 řádka)

Regards
Pavel