Contents
How to pass array or record to function in PostgreSQL?
I have a task to pass arrays, records, and in some cases array of records as a parameter to functions in PostgreSQL. Postgres has very flexible handling of arrays and composite types. This may be the sort of thing you are trying to do:
How does Postgres handle arrays and composite types?
Postgres has very flexible handling of arrays and composite types. This may be the sort of thing you are trying to do: Thanks for contributing an answer to Database Administrators Stack Exchange! Please be sure to answer the question.
How to transform columns to rows in PostgreSQL?
I want to transform the column a, b and c to rows. But I want to make it generic for any table with lots of columns. But I’m not able to replace array [a, b, c] with something dynamic. If I use: the result is not the values of the columns, but just the name of the columns. How can I unnest the values of the columns?
Can you pass a table to a function?
As far as I can tell (after googeling extensivly, because I had the same problem) you can’t pass a table directly to a function. However, as shown, you can transform a table into an array [] of a custom type that consists of several basic types (similar to a table definition).
Can a table be transformed into an array?
However, as shown, you can transform a table into an array [] of a custom type that consists of several basic types (similar to a table definition). Then you can pass that array and unnest it back into a table once you are in the function. Thanks for contributing an answer to Database Administrators Stack Exchange!
When to use integer as a parameter in PostgreSQL?
I currently have a DbCommand into which I load a call to a stored proc, add in a parameter and execute scalar to get back an Id to populate an object with. This now needs to take n integers as arguments. These are used to create child records linking the newly created record by it’s id to the integer arguments.