Re: Functions with more than 32 parameters - Mailing list pgsql-general

From David Fetter
Subject Re: Functions with more than 32 parameters
Date
Msg-id 20050210180750.GE22824@fetter.org
Whole thread Raw
In response to Functions with more than 32 parameters  ("Oisin Glynn" <me@oisinglynn.com>)
Responses Re: Functions with more than 32 parameters
List pgsql-general
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!

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: no self-joins in views?
Next
From: Christoph Pingel
Date:
Subject: Re: no self-joins in views?