Contents
How to return table, rows or record from function in PostgreSQL?
Editing one more time to add in some demo code (directly from postgresql.org documentation):
How to return a composite type in PostgreSQL?
In that case, you can return a setof record. This tells PostgreSQL that you want to the function to return an composite type but that you’re going to tell it what types to expect later. Let’s make a function that returns all the rows of a table whose name you pass in as a parameter.
How to return more than one row from PL / pgSQL?
The PL/pgSQL function is a little more complicated, but let’s go through it. The function starts off by declaring a variable r to be of the rowtype holder.
How can I return multiple rows of Records in?
I am trying to return multiple records using RECORD data type, is there a way I can append to RECORD and add/append a new value with each iteration to this RECORD. that is, I want to append to rec so that rec becomes a set of rows when the loop is over, which I can just RETURN at the end of my function. Currently, I am doing this –
How is a table function implemented in PostgreSQL?
A user-defined table function, in contrast, is implemented using either return next, to return the next explicitly computed row, or return query, to return the entire result set of a select statement. You can define the statement using either static SQL or dynamic SQL.
When to return data from a delete table?
In a DELETE, the data available to RETURNING is the content of the deleted row. For example: If there are triggers ( Chapter 36) on the target table, the data available to RETURNING is the row as modified by the triggers. Thus, inspecting columns computed by triggers is another common use-case for RETURNING.
When do you need to return data from modified rows?
Sometimes it is useful to obtain data from modified rows while they are being manipulated. The INSERT, UPDATE, and DELETE commands all have an optional RETURNING clause that supports this.