RETURN NEXT and RETURN QUERY
Syntax
When creating a function, specify SETOF datatype for the return values.
return_next_clause::=
return_query_clause::=
The syntax details are as follows:
If a function needs to return a result set, use RETURN NEXT or RETURN QUERY to add results to the result set, and then continue to execute the next statement of the function. As the RETURN NEXT or RETURN QUERY statement is executed repeatedly, more and more results will be added to the result set. After the function is executed, all results are returned.
RETURN NEXT can be used for scalar and compound data types.
RETURN QUERY has a variant RETURN QUERY EXECUTE. You can add dynamic queries and add parameters to the queries by using USING.
Examples
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
