Re: citext LIKE search bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: citext LIKE search bug
Date
Msg-id 31370.1568868253@sss.pgh.pa.us
Whole thread Raw
In response to Re: citext LIKE search bug  (Morris de Oryx <morrisdeoryx@gmail.com>)
List pgsql-bugs
Morris de Oryx <morrisdeoryx@gmail.com> writes:
> For what it's worth, the citext_pattern_ops option seems to provide
> case-blind = searches, which text_pattern_ops does not. Unless I got
> confused when I tested out the various permutations. If that's true, then
> citext_pattern_ops has value for me.

The default citext index opclass should handle that case fine ...

            regards, tom lane



pgsql-bugs by date:

Previous
From: Morris de Oryx
Date:
Subject: Re: citext LIKE search bug
Next
From: Mahendra Singh
Date:
Subject: Re: install error