Re: more than 32 parameters to a function? - Mailing list pgsql-general

From Ottavio Campana
Subject Re: more than 32 parameters to a function?
Date
Msg-id 4540F68D.60809@campana.vi.it
Whole thread Raw
In response to Re: more than 32 parameters to a function?  (Erik Jones <erik@myemma.com>)
Responses Re: more than 32 parameters to a function?  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
Re: more than 32 parameters to a function?  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
Erik Jones wrote:
> Put them in arrays and pass them as the arguments.  But, I would like to
> know what function could ever need 65 arguments?

Consider that I have to invoke the function from a ZSQL method in zope.
Do you know if it works?

I need all these arguments because we have a tables where we store items
 for an e-commerce site. The problem is that these items might have a
lot of peculiarities and more than 40 fields are boolean to fully
describe them.

Bye

> Ottavio Campana wrote:
>> I'm writing some stored procedures in pl/pgsql for a database using
>> postgresql 7.4.7.
>>
>> I need to write a complex function with 65 arguments, but when I try to
>> run it I get an error complaining that arguments can be up to 32.
>>
>> Is there a way to solve this problem or do I have to try to split the
>> function into three new ones?
>>
>>
>
>


--
Non c'e' piu' forza nella normalita', c'e' solo monotonia.


Attachment

pgsql-general by date:

Previous
From: Volkan YAZICI
Date:
Subject: Re: more than 32 parameters to a function?
Next
From: Volkan YAZICI
Date:
Subject: Re: more than 32 parameters to a function?