Hash and bools - Mailing list pgsql-hackers

From Scott Marlowe
Subject Hash and bools
Date
Msg-id Pine.LNX.4.33.0206211604240.11527-100000@css120.ihs.com
Whole thread Raw
In response to Alter table drop column and background vacuum?  ("Stephen" <jleelim@hotmail.com>)
Responses Re: Hash and bools  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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..."

So, can I cast something to make this work, or is it possible to make 
hash indexes work with bools.  There are a few instances where a small 
percentage of a table is marked false while the rest is true, or vice 
versa, where a partial hash index would be nice to try, and may not have 
the ever expanding index problem that brtees have.

-- 
"Force has no place where there is need of skill.", "Haste in every 
business brings failures.", "This is the bitterest pain among men, to have 
much knowledge but no power." -- Herodotus




pgsql-hackers by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: What is wrong with hashed index usage?
Next
From: Thomas Lockhart
Date:
Subject: Re: What is wrong with hashed index usage?