Re: Functions with more than 32 parameters

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: Functions with more than 32 parameters
Дата
Msg-id 20050210180750.GE22824@fetter.org
обсуждение исходный текст
Ответ на Functions with more than 32 parameters  ("Oisin Glynn" <me@oisinglynn.com>)
Ответы Re: Functions with more than 32 parameters  (Michael Fuhr <mike@fuhr.org>)
Список 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 по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: no self-joins in views?
Следующее
От: Christoph Pingel
Дата:
Сообщение: Re: no self-joins in views?