Scott Marlowe <scott.marlowe@ihs.com> writes:
> During the discussion of bools and hash index and partial indexes and
> index growth and everything else, I tried to make a partial index on a
> bool field and got the error that "data type bool has no default operator
> for class hash..."
Well, no. I can't see much point in hashing for a datatype with only
two values. (Of course, btree probably sucks too in this case.)
You could probably gin one up pretty quickly using the support routines
for char_ops, if you want one for testing.
regards, tom lane