Functions have 32 args limt ???
От | Ivar |
---|---|
Тема | Functions have 32 args limt ??? |
Дата | |
Msg-id | biinqf$rtf$1@sea.gmane.org обсуждение исходный текст |
Ответы |
Re: Functions have 32 args limt ???
Re: Functions have 32 args limt ??? |
Список | 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';
В списке pgsql-general по дате отправления: