Hello,
I have a small problem following statement executes well do not give me proper results, rather subquery calleing another function is not executed at all.
perform sometable.pk, (select * from somefunction) from sometable where somecondition;
But select * from somefunction; and perform * from somefunction; and also select sometable.pk, (select * from somefunction) from sometable where somecondition; gets executed properly with all side effects.
Is there anything wrong in my first statement? OR perform can not used to make join as in selects.
Thanks,
CPK