Hello there, Could anybody advise me how can I create composite index for table when one of key fields is of boolean type? Schema is as follows: create table test (indoor bool, pos int, name varchar(64) NOT NULL, check (pos >= 0 and pos <=32000)); create unique index test_pkey on test (indoor, pos); leads to error ERROR: Can't find a default operator class for type 16. Finally, I use char_ops as type class: create unique index test_pkey on test (indoor char_ops, pos); -- is it correct? Sincerely, D.Marck [DM5020, DM268-RIPE, DM3-RIPN] ------------------------------------------------------------------------ *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- [EMAIL PROTECTED] *** ------------------------------------------------------------------------
