Postgres Pro
Downloads
Home   >   mailing lists

Re: Constraint exclusion can't process simple constant expressions? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Constraint exclusion can't process simple constant expressions?
Date
Msg-id 4DAF93EF.5070102@agliodbs.com
Whole thread Raw
In response to Re: Constraint exclusion can't process simple constant expressions?  (Brendan Jurd <direvus@gmail.com>)
List pgsql-performance
Tree view 
> 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
ones, AFAICT.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-performance by date:

Previous
From: Brendan Jurd
Date:
Subject: Re: Constraint exclusion can't process simple constant expressions?
Next
From: Tom Lane
Date:
Subject: Re: Constraint exclusion can't process simple constant expressions?