'PostgreSQL how to pass more than 100 arguments to a function
I am working on writing a function in PostgreSQL, which need to have more than 100 arguments. When I tried to run statement, server complains that function can not have more than 100 arguments. So I want to know is there any way to override that limit and how? Thanks in advance.
Solution 1:[1]
Solution: You can pass one record with many columns instead. Or multiple such records.
Tip: you can also use record of type of existing table from DB or create new table type for this to have all benefits of strict-typed coding.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Evgeny Nozdrev |