> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > test=# create index myindex on accounts(aid) where bid <> 0;
Hmm ? Am I reading correctly ? a restriction that is on a field, that
is not in the index ? Does that make sense ? (aid --> bid)
> 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.
But that is sad, since it would be a rather important use. Couldn't it
be
rewritten to: (aid < 0 or aid > 0) ? (I assume you meant aid)
Andreas