> Tatsuo Ishii <t-ishii@sra.co.jp> 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