imageguy wrote:
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.
I thought it had been increased to 64, but I'm sure you're right.
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.
Ah, but it's a record, so pass a record type in:
CREATE TYPE cobol_file_type AS (a integer, b text, c varchar, d date);
CREATE FUNCTION build_tables1(c cobol_file_type)...
Each existing table has its own type defined too (with the same name),
which might save you some time.
--
Richard Huxton
Archonet Ltd
