Functions have 32 args limt ??? - Mailing list pgsql-general

Hi,

For my supprise I found that functions have 32 parameter limit.

Where to find more info about this limitation or similar limitations ?


I need at least 50, 100 would be ok.

Real life function below:

CREATE OR REPLACE FUNCTION
wpr_KA_I_PersonCard_Doc(int,varchar,varchar,varchar,varchar,varchar,varchar,
varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varc
har,varchar,varchar,varchar,varchar,timestamp,timestamp,boolean,varchar,time
stamp,timestamp,boolean,varchar,varchar,timestamp,varchar,varchar,varchar,bo
olean)
 RETURNS void AS '
DECLARE


 @DocAction              ALIAS FOR $1;
                                     -- 1 - Load Document
                                     -- 2 - Update Header
 @SessionID              ALIAS FOR $2;  -- Session ID
 @LockID                 ALIAS FOR $3;  -- Lock ID
 @Lang                   ALIAS FOR $4;  -- Language
 @PersonID               ALIAS FOR $5;

 @MainPersonCode         ALIAS FOR $6;
 @SurName                ALIAS FOR $7;
 @FirstName              ALIAS FOR $8;
 @FatherName             ALIAS FOR $9;
 @Phone                  ALIAS FOR $10;
 @WorkPhone              ALIAS FOR $11;
 @GSM                    ALIAS FOR $12;
 @Email                  ALIAS FOR $13;
 @State                  ALIAS FOR $14;
 @CountyCode             ALIAS FOR $15;
 @CountyName             ALIAS FOR $16;
 @MunicipalityCode       ALIAS FOR $17;
 @MunicipalityName       ALIAS FOR $18;
 @Address                ALIAS FOR $19;
 @ZipCode                ALIAS FOR $20;
 @PermissionToResideNr   ALIAS FOR $21;
 @PermissionToResideFrom ALIAS FOR $22;
 @PermissionToResideTo   ALIAS FOR $23;
 @NotCitizen             ALIAS FOR $24;
 @WorkPermitNr           ALIAS FOR $25;
 @WorkPermitFrom         ALIAS FOR $26;
 @WorkPermitValidTo      ALIAS FOR $27;
 @NotResident            ALIAS FOR $28;
 @ResidentState          ALIAS FOR $29;
 @HeathyCardCode         ALIAS FOR $30;
 @HeathyCardValidTo      ALIAS FOR $31;
 @BankAccount            ALIAS FOR $32;
 @BankCode               ALIAS FOR $33;
 @Sex                    ALIAS FOR $34;
 @Smoke                  ALIAS FOR $35;
BEGIN
END;
' LANGUAGE 'plpgsql';