24 Apr 2012 06:09
Re: Calling a plpgsql function with an array of results?
Naoko Reeves <naokoreeves <at> gmail.com>
2012-04-24 04:09:28 GMT
2012-04-24 04:09:28 GMT
How about
select myschema.myfunction(SELECT ARRAY(select myid from mytable));
?
--
Naoko Reeves
select myschema.myfunction(SELECT ARRAY(select myid from mytable));
?
On Mon, Apr 23, 2012 at 5:29 PM, Wells Oliver <wellsoliver <at> gmail.com> wrote:
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 <at> gmail.com
--
Naoko Reeves
RSS Feed