Arun
Reputation: 1
How to rewrite a Postgres function to return a scalar value and a table value (instead of a refcursor)?
I have a function that returns two OUT parameters: one is a scalar value and the other is a refcursor.
I don't want to use refcursor as OUT parameter, since it is not compatible with power builder. I need that function to return one scalar value and a table.
Upvotes: 0
Views: 471
Answers (1)
Laurenz Albe
Reputation: 247665
You cannot have a function return both a scalar and a table. It is either/or.
You could return a table with an added column that is the scalar and is the same for all result rows. Or write two functions.
Upvotes: 1
Related Questions
- Calling a function that returns a refcursor
- Function to use as a query variable to return a result
- Postgres function passing table reference and string in RETURN QUERY
- Simple PostgreSQL function to return rows
- How can I return an additional column of a table without having to repeat all column names and types in the return definition?
- Postgres: use function that returns a string in another function
- How can a Postgres Stored Function return a table
- Return record with column definition from a function
- need different return format from postgres function
- how to use postgresql function in another function which returns set of Refcursor