Re: Custom Operator for citext LIKE predicates question - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Custom Operator for citext LIKE predicates question
Date
Msg-id 3151122.1642086632@sss.pgh.pa.us
Whole thread Raw
In response to Re: Custom Operator for citext LIKE predicates question  ("Efrain J. Berdecia" <ejberdecia@yahoo.com>)
Responses Re: Custom Operator for citext LIKE predicates question
List pgsql-hackers
"Efrain J. Berdecia" <ejberdecia@yahoo.com> writes:
> In our setup it has actually worked per the explains provided making the query run in milliseconds instead of
seconds.

To me, "work" includes "get the right answer".  I do not think you
are getting the same answers that citext would normally provide.
If you don't care about case-insensitivity, why don't you just
use plain text?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Dmitry Dolgov
Date:
Subject: Re: 2022-01 Commitfest
Next
From: Floris Van Nee
Date:
Subject: RE: MDAM techniques and Index Skip Scan patch