Re: Custom Operator for citext LIKE predicates question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Custom Operator for citext LIKE predicates question
Дата
Msg-id 3151122.1642086632@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Custom Operator for citext LIKE predicates question  ("Efrain J. Berdecia" <ejberdecia@yahoo.com>)
Ответы Re: Custom Operator for citext LIKE predicates question  ("Efrain J. Berdecia" <ejberdecia@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Dmitry Dolgov
Дата:
Сообщение: Re: 2022-01 Commitfest
Следующее
От: Floris Van Nee
Дата:
Сообщение: RE: MDAM techniques and Index Skip Scan patch