How about select myschema.myfunction(SELECT ARRAY(select myid from mytable)); ?
On Mon, Apr 23, 2012 at 5:29 PM, Wells Oliver <wellsoli...@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 > wellsoli...@gmail.com > -- Naoko Reeves http://www.anypossibility.com/
