Re: pgsql: Handle equality operator in contrib/pg_trgm
| От | Laurenz Albe |
|---|---|
| Тема | Re: pgsql: Handle equality operator in contrib/pg_trgm |
| Дата | |
| Msg-id | a0a6a902cdf1112e73c29df0d31458becfbf793d.camel@cybertec.at обсуждение исходный текст |
| Ответ на | pgsql: Handle equality operator in contrib/pg_trgm (Alexander Korotkov <akorotkov@postgresql.org>) |
| Список | pgsql-committers |
On Sun, 2020-11-15 at 05:53 +0000, Alexander Korotkov wrote: > Handle equality operator in contrib/pg_trgm > > Obviously, in order to equality operator be satisfiable, target string must > contain all the trigrams of the search string. On this base, we implement > equality operator in GiST/GIN indexes with recheck. > > Discussion: https://postgr.es/m/CAOBaU_YWwtT7tdggtROacjdOdeYHCz-tmSwuC-j-TOG-g97J0w%40mail.gmail.com > Author: Julien Rouhaud > Reviewed-by: Tom Lane, Alexander Korotkov, Georgios Kokolatos, Erik Rijkers > > Branch > ------ > master > > Details > ------- > https://git.postgresql.org/pg/commitdiff/935f6666502250abde8615bc7805a6e5aa05a066 This causes bad query results with non-deterministic collations, see https://postgr.es/m/8ef4899c4acfebca45cc6c042a6dc611d25ffab1.camel@cybertec.at Yours, Laurenz Albe
В списке pgsql-committers по дате отправления: