Re: Is there a way to pass more than 32 parameters to a

On Wed, 16 Jul 2003, Jon Brazus wrote:

>
> Does anyone know of a way to pass more than 32 parameters to a plpgsql
> function?  The 7.3 release documentation states that fuctions can now
> take up to 32 parameters "by default", which implies that perhaps this
> can be changed with a tuning parameter or some such.  Or failing that,
> does anyone know if this limit is going to be increased again in the 7.4
> release?  Any help is appreciated.

sure, you need to edit

pg_config.h.in and change the #define FUNC_MAX_ARGS line to whatever you
want. Then run .configure --yourswtichesgohere and make install.

Note that this requires a dump / restore, if I remember correctly.