Re: Functions with more than 32 parameters

On Wed, Feb 09, 2005 at 10:11:19PM -0500, Oisin Glynn wrote:
> Hi,
>
> I am trying to keep database access encapsulated in functions from an
> insert and update point of view so as all of the applications writing to
> the database are using the same functions/statements.
>
> My problem is I was creating functions to do inserts/updates and now I have
> a table with more than 32 columns and the functions seem to only want to
> have 32 parameters?
>
> Is there any way around this?

Short of recompiling as others have suggested, you could put large #
of params into an array and have the function unwind that.

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!