Tore Halvorsen escribió: > Hi, > > Is it possible to use an index for like queries on a citext column? > I'm using pg 8.4.1 on windows - with no changes to the default configuration. > > For example: > > CREATE TABLE test ( citext citext NOT NULL ); > INSERT INTO test select md5(random()::text) FROM generate_series(0, 1000000, > 1); > CREATE INDEX test_citext_idx ON test USING btree(citext);
Hmm, I think this needs one of the *_pattern_ops indexes. I'm not sure if you can use the builtin ones with citext though. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
