Re: partial index

Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> writes:
> test=# create index myindex on accounts(aid) where bid <> 0;

> test=# explain select * from accounts where aid < 10 and bid <> 0;

> and I got a log message:

> DEBUG: clause_pred_clause_test: unknown pred_op

> Is this normal?

Yes. We might want to suppress those DEBUG messages before release.
The original implementation would have refused to let you create a
partial index with such a WHERE clause, since <> isn't a btree-indexable
operator. We agreed to let people create such indexes --- but
indxpath.c's little theorem-prover can't do anything with such a
predicate, and it complains about it.

regards, tom lane