Re: Functions have 32 args limt ??? - Mailing list pgsql-general

From Tom Lane
Subject Re: Functions have 32 args limt ???
Date
Msg-id 24253.1062087102@sss.pgh.pa.us
Whole thread Raw
In response to Re: Functions have 32 args limt ???  ("Ivar" <ivar@lumisoft.ee>)
List pgsql-general
"Ivar" <ivar@lumisoft.ee> writes:
> Are there any real pefrormance difference, what are actual difference(%),
> have somebody measured even it ?

You still haven't looked at the thread you were pointed to, have you?

There is another issue besides disk space and performance, which is that
functions with large numbers of positional parameters are just plain bad
style --- it's way too easy to introduce bugs by passing the parameters
in the wrong order.  It's usually better to coalesce some of the
parameters into arrays or records.  Our awareness of this fact keeps us
from wanting to expend lots of work or resources on making the standard
function argument limit larger.

            regards, tom lane

pgsql-general by date:

Previous
From: Jeffrey Melloy
Date:
Subject: Re: Books for PostgreSQL?
Next
From: "Ivar"
Date:
Subject: Re: Functions have 32 args limt ???