Josh Berkus <josh@agliodbs.com> writes:
> On 7/11/09 3:50 AM, Greg Stark wrote:
>> Hm. Actually maybe not. What if the index is an expression index and
>> the expression includes a function which does an SQL operation? I'm
>> not sure how realistic that is since to be a danger that SQL operation
>> would have to be an insert, update, or delete which is not just
>> bending the rules.
> It's not realistic at all. People are only supposed to use IMMUTABLE
> functions for experession indexes; if they declare a volatile function
> as immutable, then it's their own lookout if they corrupt their data.
The requirement wasn't just on not changing SQL data though. To make
use of this you'd also have to forbid indexed functions from *reading*
other tables. Which is something we discourage because of the risk that
the results aren't really immutable, but we don't forbid it; and there
are obvious use-cases.
regards, tom lane
