Re: Functions have 32 args limt ???

If I understand right, you cant pass record from client apps, eg. C# or VB.

"Dennis Gearon" <gearond(at)fireserve(dot)net> wrote in message
news:3F4D5E6D(dot)5030507(at)fireserve(dot)net(dot)(dot)(dot)
> 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,var
c
>
>har,varchar,varchar,varchar,varchar,timestamp,timestamp,boolean,varchar,tim
e
>
>stamp,timestamp,boolean,varchar,varchar,timestamp,varchar,varchar,varchar,b
o
> >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
> >
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>