Stephan Szabo <sszabo@xxxxxxxxxxxxxxxxxxxxx> writes: > On Wed, 22 Nov 2006, Alexander Presber wrote: >> CREATE INDEX idx_main_subject ON pdb.main (lower(main_subject::text) >> using varchar_ops); > IIRC, unless you're in C locale, you'll want varchar_pattern_ops rather > than varchar_ops on the index to make it considered for a LIKE search. text_pattern_ops would be better, seeing that the output of lower() is text not varchar. I'm a bit surprised the planner is able to make use of this index at all. regards, tom lane
