16 Argument Limit ?!?!?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема 16 Argument Limit ?!?!?
Дата
Msg-id web-1189015@davinci.ethosmedia.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: How to make operator class?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: fetching the id of a new row