> You may be thinking of the STABLE volatility level. It requires that
> the results of the function are the same for the same inputs, within
> the same transaction.
Right. But CE will only pay attention to immutable values, not stable
PostgreSQL Experts Inc.
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2011-04-21 02:44:50|
|Subject: Re: Constraint exclusion can't process simple constant expressions? |
|Previous:||From: Brendan Jurd||Date: 2011-04-21 02:17:11|
|Subject: Re: Constraint exclusion can't process simple constant expressions?|