Tatsuo Ishii <t-ishii@sra.co.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