> Tatsuo Ishii <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
