AW: partial index

> Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)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