Re: Custom Operator for citext LIKE predicates question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Efrain J(dot) Berdecia" <ejberdecia(at)yahoo(dot)com>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Custom Operator for citext LIKE predicates question
Date: 2022-01-13 15:10:32
Message-ID: 3151122.1642086632@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Efrain J. Berdecia" <ejberdecia(at)yahoo(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Floris Van Nee 2022-01-13 15:27:08 RE: MDAM techniques and Index Skip Scan patch
Previous Message Dmitry Dolgov 2022-01-13 15:04:31 Re: 2022-01 Commitfest