Hello,
I’m not quite sure, what’s the difference between RETURN NEXT and RETURN QUERY.
From the documentation (Sec. 38.6) RETURN NEXT returns a table and in my understanding with each execution a different table.
RETURN QUERY appends a result set of a query to the function’s result set, i.e. the function returns at most one table.
Where is the difference for the caller? That means: how to determine if one or several tables have been returned?
The result of the function is always of type TABLE/SETOF RECORD.