> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > It seems partial indexes with not null condition do not work:
>
> What you created wasn't a partial index, it was a functional index.
> Try something like
> create index nonnullindex on accounts(bid) where bid is not null;
Sorry for the confusing and foolish question. However still I wonder
why my expression(functional) index does not work.
--
Tatsuo Ishii
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
