Adding -docs...
On Fri, Jan 13, 2006 at 07:27:28PM -0500, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > Is the issue that the optimizer won't combine two function calls (ie:
> > SELECT foo(..) ... WHERE foo(..)), or is it that sometimes it won't make
> > the optimization (maybe
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Is the issue that the optimizer won't combine two function calls (ie:
> SELECT foo(..) ... WHERE foo(..)), or is it that sometimes it won't make
> the optimization (maybe depending on the query plan, for example)?
What the STABLE category actually does
On Wed, Jan 11, 2006 at 11:33:23PM -0500, Tom Lane wrote:
> Mark Liberman <[EMAIL PROTECTED]> writes:
> > I've got a set-returning function, defined as STABLE, that I reference
> > twice
> > within a single query, yet appears to be evaluated via two seperate
> > function
> > scans.
>
> There i
Mark Liberman <[EMAIL PROTECTED]> writes:
> I've got a set-returning function, defined as STABLE, that I reference twice
> within a single query, yet appears to be evaluated via two seperate function
> scans.
There is no guarantee, express or implied, that this won't be the case.
(Seems like we
Hi,
I've got a set-returning function, defined as STABLE, that I reference twice
within a single query, yet appears to be evaluated via two seperate function
scans. I created a simple query that calls the function below and joins the
results to itself (Note: in case you wonder why I'd do suc
