November 13th, 2002, 03:15 AM
ERROR: Procedures cannot take more that 16 arguments..
I'm new to PostGres... When I created a stored function, an insert function which has 31 arguments, I recieve this error. Is this the limitation of PostGres? Or I miss somthing here?
Please do help me, thanks a lot....
November 13th, 2002, 10:02 AM
Yes, if you look in the Notes section at the bottom of this page, you will see:
You can probably best handle this simply by re-thinking your function. For example you might be able to make one argument as an array (http://www.postgresql.org/idocs/index.php?arrays.html), and then extract all your elements inside the function for your insert statement.
If you are having any more trouble, feel free to post your function code here, and we can suggest alternatives.
Last edited by rycamor; November 13th, 2002 at 11:48 AM.
December 4th, 2002, 05:07 PM
If you hadn't noticed, PostgreSQL 7.3 is out. It's a major release. Among many new improvements, functions can now take up to 32 parameters.