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

From Volkan YAZICI
Subject Re: more than 32 parameters to a function?
Date
Msg-id 20061026180808.GE1377@alamut
Whole thread Raw
In response to Re: more than 32 parameters to a function?  (Ottavio Campana <ottavio@campana.vi.it>)
List pgsql-general
On Oct 26 10:55, Ottavio Campana wrote:
> 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.

I don't have a clue about the ZSQL issue, but it can be a solution to OR
those booleans, with some bitwise logic.


Regards.

pgsql-general by date:

Previous
From: Ottavio Campana
Date:
Subject: Re: more than 32 parameters to a function?
Next
From: Vivek Khera
Date:
Subject: Re: Monitoring Postgres - Get the SQL queries which are sent to postgres