Function Scan
Description
Function scan is used to execute a function and obtain tuples from the result set returned by the function.
Typical Scenarios
When a query needs to call a function and return a result set, the function scan operator can call the function and obtain tuples from the result set returned by the function.
Examples
Call a system function.
gaussdb=# EXPLAIN SELECT * FROM generate_series(2,4);
QUERY PLAN
------------------------------------------------------------------------
Function Scan on generate_series (cost=0.00..10.00 rows=1000 width=4)
(1 row)
In the preceding example, the output of the function scan operator is as follows.
Item |
Description |
---|---|
Function Scan |
Operator name. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot