Re: Functions have 32 args limt ???

You might fnd a RECORD type better.

Ivar wrote:

>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';
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>