Re: Hash and bools

Scott Marlowe <scott(dot)marlowe(at)ihs(dot)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