Re: Functions have 32 args limt ???

Ivar wrote:

>I don't see why default is so small.
>
>"Joe Conway" <mail(at)joeconway(dot)com> wrote in message
>news:3F4D8DE0(dot)1060307(at)joeconway(dot)com(dot)(dot)(dot)
>
>
>>Ivar wrote:
>>
>>
>>>For my supprise I found that functions have 32 parameter limit.
>>>
>>>Where to find more info about this limitation or similar limitations ?
>>>
>>>I need at least 50, 100 would be ok.
>>>
>>>
>>See INDEX_MAX_KEYS defined in src/include/pg_config.h.in
>>(pg_config_manual.h in postgres 7.4). Change to 64 or whatever and
>>recompile. But note that you'll need to dump, initdb, and reload your
>>data. Also note that there are performance and disk usage tradeoffs --
>>search the mailing list archives from August 2002 for some test results
>>and discussion.
>>
>>Joe
>>
>>
>>---------------------------(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
>>
>>
>>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>
32 is small? I've never designed a function with more than 12-18, at teh
MOST, arguments.