I am attempting to port and application that was designed for MS-SQL
to Postgres and bumped into a limitation of pg functions, namely that
pg functions can only support 32 parameters.
Our app takes records from a only cobol file(s) and populates an SQL
table(s), such that one table in the db = one file from the file
system.
With MS-SQL we use a stored procedure to handle the update/inserts and
pass the fields information as parameters to the procedure as part of
"EXECUTE" command. Sometimes there can be as many as 50+ parameters
to be passed.
Typically pg functions as offered as the equivalent to "store
procedures", however, in this case seems to be a limitation.
If anyone has any other suggestions, we would appreciate some input.