Re: IMMUTABLE function's flag do not work: 7.3.4, plpgsql

On Wed, 8 Oct 2003, Tom Lane wrote:

> Andriy Tkachuk <ant(at)imt(dot)com(dot)ua> writes:
> > At second. calc_total() is immutable function:
> > but it seems that it's not cached in one session:
>
> It's not supposed to be.

but it's written id doc:

IMMUTABLE indicates that the function always returns the same
result when given the same argument values; that is, it does not
do database lookups or otherwise use information not directly
present in its parameter list. If this option is given, any call
of the function with all-constant arguments can be immediately
replaced with the function value.

I meant that the result of calc_total() is not "immediately replaced with the function value"
as it's written in doc, but it takes as long time as the first function call
in the session (with the same arguments).

Maybe i misunderstand something?

Thank you,
Andriy Tkachuk.

http://www.imt.com.ua