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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
