Stefan Zauchenberger <stefan@ice-sys.com> writes:
> I am having a problem creating a parent function that calls different functions within based on conditions. The
functionswithin all take the exact same arguments and return the same set type. This must be a simple mistake on my
part,but not sure of the fix.
If you're trying to pass a set result back up, the easiest way is to
use "RETURN QUERY SELECT * FROM child_function(...)". Plain "RETURN"
only works for scalar results, and RETURN NEXT is for producing a
result-set one row at a time.
regards, tom lane