功能有32个args limt ??? [英] Functions have 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; < br $>
@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 FUNCTION
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 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

解决方案

1;
-- 1 - Load Document
-- 2 - Update Header
@SessionID ALIAS FOR

2; -- Session ID
@LockID ALIAS FOR

3; -- Lock ID
@Lang ALIAS FOR

这篇关于功能有32个args limt ???的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！