Re: more than 32 parameters to a function?

From: Ottavio Campana <ottavio(at)campana(dot)vi(dot)it>
To: Erik Jones <erik(at)myemma(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: more than 32 parameters to a function?
Date: 2006-10-26 17:55:25
Message-ID: 4540F68D.60809@campana.vi.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Volkan YAZICI 2006-10-26 18:08:08 Re: more than 32 parameters to a function?
Previous Message Volkan YAZICI 2006-10-26 17:52:08 Re: more than 32 parameters to a function?