Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> writes:
> Both the functions used in functional indexes and the
> predicates used in partial indexes must be deterministic.
> Are users responsible for it ?
>>
>> Yes. I don't see how the system could enforce that, without
>> prohibiting lots of useful cases.
> Shouldn't the functions be *cacheable* at least ?
Hmm. We could do that, although of course it's not a bulletproof check.
Any objections out there?
regards, tom lane