Tom Lane wrote:
> Milan Oparnica <milan.opa@gmail.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