Thread: Why their is a limit in Postgresql (psql) Parameters..?

<div style="background-color:"><div><p>Hi All,<p>     I'm using Postgresql v7.3.3. I have a small question ...<p><br
/>    Why is that there is a maximum limit of 32 input parameters to the<br />Postgresql function?<br />     
Whereas storedprocedures in Oracle and SQL Server<br />take more than 32 input arguments. So this puts extra burden on
the<br/>middleware developer to handle this stiuation at the time of migrating<br />existing databases in SQL Server or
Oracleto Postgresql.<p>Any Info/Suggestions will be highly appreciated.<p> <p> <p><br /><br /><br /><br
/> </div></div><brclear="all" /><hr />Are you Unmarried? <a href="http://g.msn.com/8HMFENIN/2755??PS=">Register in
India'sNo 1 Matrimony</a> 

On Monday 21 July 2003 11:29, vijaykumar M wrote:
> Hi All,
>
>     I'm using Postgresql v7.3.3. I have a small question ...
>
>     Why is that there is a maximum limit of 32 input parameters to the
> Postgresql function?
>       Whereas stored procedures in Oracle and SQL Server
> take more than 32 input arguments. So this puts extra burden on the
> middleware developer to handle this stiuation at the time of migrating
> existing databases in SQL Server or Oracle to Postgresql.

It used to be 16 and was increased to 32 fairly recently (hmm - 7.3.0 
according to the release notes). People used to tweak and recompile the 
source to increase from 16, so I suppose you could still do the same. Have a 
look in the mailing list archives, I seem to remember messages on this in the 
past.

The reason why it's not bigger is that there hasn't been enough people saying 
"I need more parameters".

--  Richard Huxton Archonet Ltd

> The reason why it's not bigger is that there hasn't been enough people saying
> "I need more parameters".

That and a general speed penalty to all users of all functions.

Make (whatever) the limitation is affect only those using a large number
of parameters and you will find the limit set to a fairly high number.