On 10/8/15, Zsb?n Ambrus <ambrus at math.bme.hu> wrote: > > There is one apparent inconsistency I was wondering about. For a > partial index, the WHERE clause of the index cannot contain functions; > whereas for an index on an expression, the expression can contain > deterministic functions. What is the explanation of this difference? > Is it only historical, because the deterministic functions flag is a > new addition? >
It is historical. -- D. Richard Hipp drh at sqlite.org