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 likecreate index nonnullindex on accounts(bid) where bid is not null;
regards, tom lane