Thread: number of parameters to a stored procedure

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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

"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