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