Re: Function Parameters

Поиск
Список
Период
Сортировка
От Pierre-Frédéric Caillaud
Тема Re: Function Parameters
Дата
Msg-id opsjy2ltmgcq72hf@musicbox
обсуждение исходный текст
Ответ на Re: Function Parameters  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
    Maybe you could use arrays as some function parameters ?

    Can you explain why you need so many parameters ?

On Sat, 1 Jan 2005 22:25:02 -0700, Michael Fuhr <mike@fuhr.org> wrote:

> On Sun, Jan 02, 2005 at 01:31:22AM +0000, Oluwatope Akinniyi wrote:
>
>> I tried to create a function with about 60 input parameters and got an
>> error message that a function cannot take more than 32 parameters.
>
> What's the function's purpose?  Why does it need so many arguments?
> You might be able to get around the limitation with a composite
> type, but maybe there's a different way to do what you want.
>
> Another possibility would be to rebuild PostgreSQL and change the
> limit.  I don't know what the implications are other than what the
> comment in the code says: "There is no specific upper limit, although
> large values will waste system-table space and processing time" and
> "Changing these requires an initdb."
>



В списке pgsql-general по дате отправления:

Предыдущее
От: Pierre-Frédéric Caillaud
Дата:
Сообщение: Re: many similar indexbased selects are extremely slow
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: disabling OIDs?