[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Calling a plpgsql function with an array of results?



Trying to call my function like so:

select myschema.myfunction(select myid from mytable);

myfunction has the signature: myfunction(integer[])

myid is an integer; I am trying to select them as an array to pass to the function.

Where am I going wrong? Thanks!

--
Wells Oliver
wellsoliver@xxxxxxxxx

[Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

Powered by Linux