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
