"Sergey Koshcheyev" <[EMAIL PROTECTED]> writes:
> this is an addition to my bug report #1470. I have found that if I have a
> boolean column and create an index on it, it doesn't get picked up for
> conditions like "WHERE column" or "WHERE NOT column", only "WHERE column =
> true" or "WHERE column = false".
> Do you consider this worth fixing?
No; mainly because a btree index on a boolean column is ordinarily a
waste of disk space.
A partial index (with some non-boolean column as the nominally indexed
data) is generally a better solution.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
