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;
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
