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.
--
Regards,
Robert...