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
>
>
>