Re: Functions have 32 args limt ??? - Mailing list pgsql-general
| From | Ivar |
|---|---|
| Subject | Re: Functions have 32 args limt ??? |
| Date | |
| Msg-id | bik4j3$na7$1@sea.gmane.org Whole thread Raw |
| In response to | Functions have 32 args limt ??? ("Ivar" <ivar@lumisoft.ee>) |
| List | pgsql-general |
If I understand right, you cant pass record from client apps, eg. C# or VB. "Dennis Gearon" <gearond@fireserve.net> wrote in message news:3F4D5E6D.5030507@fireserve.net... > 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 >
pgsql-general by date: