Re: Hash and bools

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