Re: Plpgsql function with unknown number of args

You don't have to cast it as anything, just return a refcursor from your
function.

Say you return a refcursor called return_cursor

select myfunction(your_in_array);
fetch all from return_cursor;

If you are calling from a development environment, you put the return
value of the fuction (the refcursor name) into a variable, then
dynamicly build the fetch
all statement from return value of the function.  This must be done in
the context of a transaction, i.e. both statements must must be executed
in the same transaction.

The refcursors work really well and are very flexible.

Relyea, Mike wrote:

>Thanks for the input.  This looks very promising.  I have one further
>question.  My SQL statement is going to pull data from more than one
>table in a relatively complex query.  How do I cast the RETURNS portion
>of the function?  Again, I can't find what I'm looking for in the docs.
>I've included an actual sample SQL statement.  I will only be changing
>the first portion of the WHERE clause.
>
>