create table foo(b boolean);
create index foo_index on foo(b);
You get a "no default operator for type 16." error...
This ecommerce datamodel I'm porting over uses such indices
frequently, apparently to grab small subsets of large tables which
have few rows with the predicate set to one state. Even if such
an index might be of dubious usefulness in situations where
the table's population is more evenly split, there's no real
reason not to support indexes on booleans, is there?
- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.