Postgres Pro
Downloads
Home   >   mailing lists

Calling a plpgsql function with an array of results? - Mailing list pgsql-admin

From Wells Oliver
Subject Calling a plpgsql function with an array of results?
Date
Msg-id CAOC+FBVKX9y1Cpb2ZSv2mnykWo7w9cwmorpXeh=Q1Je+SY5DLg@mail.gmail.com
Whole thread Raw
Responses Re: Calling a plpgsql function with an array of results?
List pgsql-admin
Tree view
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@gmail.com

pgsql-admin by date:

Previous
From: Jesper Krogh
Date:
Subject: Re: Partial substrings in FTS
Next
From: Naoko Reeves
Date:
Subject: Re: Calling a plpgsql function with an array of results?