Thread: PL/PGSQL Array Parameters

PL/PGSQL Array Parameters

From
"Josh Berkus"
Date:
Folks,

Can anyone confirm whether it is possible, using 7.0.3, to
pass an array from PHP into a PL/PGSQL function as an input
parameter?  Basically I want to do this:

CREATE FUNCTION insert_client (name, address, preferences
ARRAY(1 to 10)) etc ...

Then call the function passing a PHP array variable directly
to the preferences input parameter.

Is this currently supported?  If so, can anybody give me a
sample of how they've st it up?  Grazie!

-Josh berkus