功能有32个args limt ???

本文介绍了功能有32个args limt ???的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 我觉得我发现函数有32个参数限制。 哪里可以找到有关此限制的更多信息或类似的限制？ 我需要至少50,100就可以了。 下面的真实生活功能： 创建或替换功能 wpr_KA_I_PersonCard_Doc（int，varchar，varchar，varcha r，varchar，varchar，varchar， varchar，varchar，varchar，varchar，varchar，varchar， va rchar，varchar，varchar，varc har，varchar，varchar，varchar，varchar，timestamp，time stamp，boolean，varchar，time stamp，timestamp，boolean， varchar，varchar，timestamp，varchar，varchar，varchar，bo olean） RETURNS void AS'' DECLARE @DocAction ALIAS $ 1; - 1 - 装载文件 - 2 - 更新标题 @SessionID ALIAS $ 2 ; - 会议ID @LockID ALIAS $ 3; - 锁定ID @Lang ALIAS 4美元; - 语言 @PersonID ALIAS $ 5; @MainPersonCode ALIAS $ 6; @SurName ALIAS $ 7; @FirstName ALIAS $ 8; @FatherName ALIAS $ 9; @Phone ALIAS $ 10; @ WorkPhone ALIAS只需11美元; @GSM ALIAS只需12美元; @Email ALIAS只需13美元; @State ALIAS只需14美元; @CountyCode ALIAS $ 15; @CountyName ALIAS $ 16; @MunicipalityCode ALIAS $ 17; @MunicipalityName ALIAS只需$ 18; @地址ALIAS $ 19; @ZipCode ALIAS $ 20; @ PermissionToResideNr ALIAS $ 21; @ PermissionToReside来自ALIAS，价格为22美元; @PermissionToReside以超过23美元的价格; @NotCitizen A LIAS只需24美元; @WorkPermitNr ALIAS只需25美元; @WorkPermitFrom ALIAS只需26美元; @WorkPermitValidTo ALIAS只需27美元; @NotResident ALIAS $ 28; @ResidentState ALIAS $ 29; @HeathyCardCode ALIAS $ 30; @HeathyCardValidTo ALIAS FOR $ 31; @BankAccount ALIAS $ 32; @BankCode ALIAS $ 33; @Sex ALIAS $ 34; @Smoke ALIAS $ 35; BEGIN END; ''LANGUAGE''plpgsql''; ---------------------------（广播结束）-------- ------------------- 提示5：您查看了我们广泛的常见问题解答吗？ http://www.postgresql.org/docs/faqs/FAQ.html 解决方案 1; - 1 - 加载文件 - 2 - 更新标题 @SessionID ALIAS FOR 2; - 会话ID @LockID ALIAS FOR 3; - 锁定ID @Lang ALIAS FOR 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 FUNCTIONwpr_KA_I_PersonCard_Doc(int,varchar,varchar,varcha r,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,va rchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,timestamp,time stamp,boolean,varchar,timestamp,timestamp,boolean,varchar,varchar,timestamp, varchar,varchar,varchar,boolean)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;BEGINEND;'' LANGUAGE ''plpgsql''; ---------------------------(end of broadcast)---------------------------TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html 解决方案 1;-- 1 - Load Document-- 2 - Update Header@SessionID ALIAS FOR2; -- Session ID@LockID ALIAS FOR3; -- Lock ID@Lang ALIAS FOR 这篇关于功能有32个args limt ???的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！