Tatsuo Ishii <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
