Hello, I am using PostgreSQL 6.4.2. and it seems I can't create indexes on BOOL columns. I tried this: $ psql template1 template1=> CREATE DATABASE test\g CREATEDB template1=> CREATE TABLE users (id INT DEFAULT 0 NOT NULL,name TEXT,preferred_name TEXT,email TEXT,alias VARCHAR (12) DEFAULT '0' NOT NULL,password TEXT,reminder TEXT,notify_any CHAR (1) DEFAULT 't' NOT NULL,notify_new CHAR(1) DEFAULT 't' NOT NULL,notify_changed CHAR(1) DEFAULT 't',edit_users CHAR(1) DEFAULT 'f')\g CREATE template1=> CREATE INDEX users_notify ON users (notify_any,notify_new)\g ERROR: Can't find a default operator class for type 16 However, if I change the BOOL type to CHAR (1) it works. Is this a bug? A configuration problem? What? Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp -- ************
