Tore Halvorsen <tore.halvor...@gmail.com> writes:
> On Tue, Sep 22, 2009 at 8:49 PM, Alvaro Herrera
> <alvhe...@commandprompt.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
