"Donald Fraser" writes:
Is the returned value of a function defined as IMMUTABLE cached =
globally?
"Tom Lane" writes:
No, in fact it isn't cached at all. IMMUTABLE tells the planner that
it's OK to fold a function call with constant inputs to a constant
result value at plan time. Nothing mo
On Thu, Jun 23, 2005 at 02:26:23PM +0100, Donald Fraser wrote:
>
> Is the returned value of a function defined as IMMUTABLE cached
> globally? In other words could postgresql potentially return a
> cached value obtained from one client session to a different client
> session?
You could experiment
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> Is the returned value of a function defined as IMMUTABLE cached =
> globally?
No, in fact it isn't cached at all. IMMUTABLE tells the planner that
it's OK to fold a function call with constant inputs to a constant
result value at plan time. Nothing m
On Thu, Jun 23, 2005 at 02:26:23PM +0100, Donald Fraser wrote:
> Is the returned value of a function defined as IMMUTABLE cached
> globally? In other words could postgresql potentially return a cached
> value obtained from one client session to a different client session?
Return values from functi
