|
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... |
