| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Ottavio Campana <ottavio(at)campana(dot)vi(dot)it> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: more than 32 parameters to a function? |
| Date: | 2006-10-26 18:27:43 |
| Message-ID: | 20061026182743.GD13440@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Oct 26, 2006 at 10:03:27AM -0700, 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?
You can pass the function one complex type that has as many parts as
you like. Or several complex types if that makes more sense.
Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-10-26 18:29:59 | Re: more than 32 parameters to a function? |
| Previous Message | Vivek Khera | 2006-10-26 18:11:04 | Re: Monitoring Postgres - Get the SQL queries which are sent to postgres |