Re: Number or parameters for functions - limited to 32 ?

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