Tore Halvorsen <tore.halvorsen@xxxxxxxxx> writes: > On Tue, Sep 22, 2009 at 8:49 PM, Alvaro Herrera > <alvherre@xxxxxxxxxxxxxxxxx> wrote: >> Tore Halvorsen escribió: >>> Is it possible to use an index for like queries on a citext column? >> 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. > Looks like I'm stuck with lower(text_col) for now... Afraid so --- there are special cases in the planner for LIKE, and that code only knows about the built-in types. Sometime we should figure out how to push that logic out to datatype-specific code so it can be more extensible. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
