number of parameters to a stored procedure

Started by Steven D. Arnoldover 24 years ago2 messagesgeneral
Jump to latest
#1Steven D. Arnold
stevena@neosynapse.net

Hello all,

It is my understanding that 16 parameters are allowed in a stored
procedure. If this is correct (please advise if not):

1. What are the reasons for this limitation?
2. Are there any plans to increase this number, say to 32 parameters, and
if so, when is this change expected?
3. If there are no imminent plans to support this, would a patch increasing
the number of parameters to 32 be seriously considered?

Thanks in advance!

------------------------------------------------------------------------
Steven D. Arnold stevena@neosynapse.net
AIM: abraxan ICQ: 73804392
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Steven D. Arnold (#1)
Re: number of parameters to a stored procedure

"Steven D. Arnold" <stevena@neosynapse.net> writes:

It is my understanding that 16 parameters are allowed in a stored
procedure. If this is correct (please advise if not):

See INDEX_MAX_KEYS/FUNC_MAX_ARGS in src/include/config.h (or config.h.in
if you haven't yet run configure). There are no plans to change the
default value, but feel free to build yourself an installation with a
larger value.

regards, tom lane