| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Oluwatope Akinniyi <topeakinniyi(at)shepherdhill(dot)biz> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Function Parameters |
| Date: | 2005-01-02 05:25:02 |
| Message-ID: | 20050102052502.GA13758@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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."
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Scott | 2005-01-02 06:05:12 | Re: Can't change password? |
| Previous Message | Bruno Wolff III | 2005-01-02 04:42:06 | Re: Question on a select |