Re: JOIN results of refcursor functions

Tom Lane wrote:
> Milan Oparnica <milan(dot)opa(at)gmail(dot)com> writes:
>> Is there any way to use INNER, LEFT and RIGHT JOIN between functions
>> returning refcursor type.
>
> No. Make them return setof whatever instead.
>
> regards, tom lane
>
I would like yo avoid creating custom composite types required for setof.

Is there any function I could use to retrieve the SQL command from named
bound cursor from inside another function ?

Idea:

a. I declare a refcursor function "C1Ref" as select...from <table>

b. In the new function (also of refcursor type) where I want to join
C1Ref to something I replace the C1Ref call with SQL query text of that
cursor (simply as a subquery).

For this to work I must have a way to get C1Ref cursors SQL text in the
new function.

If possible, please give a small example because I'm quite new to PG and
I still find very few examples on the web. PG is excellent, but I can't
navigate through the documentation well.

Thanks,

Milan Oparnica