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 [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
