16 Argument Limit ?!?!? - Mailing list pgsql-sql

From Josh Berkus
Subject 16 Argument Limit ?!?!?
Date
Msg-id web-1189015@davinci.ethosmedia.com
Whole thread Raw
List pgsql-sql
Tom, Jan,
After spending an entire day writing and debugging a
particularly complex PLPGSQL function, I just received this
error:

Procedures Cannot Take More than 16 Arguments.
This is a truly devastating blow to my application (which
is already behind schedule, needless to say).  I've been
using Functions to control all mods and additions to the
program's data tables.  I guess I just haven't had to wirte
a function for a table with more than 16 columns yet.
The current function uses 36 parameters, 3 of which are
arrays.
     Is there any way around this?  Maybe something using
the RECORD data type?  Can anyone help me with an
explanation of the RECORD data type and how to get data into
and out of it?

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: How to make operator class?
Next
From: Richard Huxton
Date:
Subject: Re: fetching the id of a new row