| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Alexander Korotkov <akorotkov(at)postgresql(dot)org>, pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pgsql: Handle equality operator in contrib/pg_trgm |
| Date: | 2024-09-20 20:19:26 |
| Message-ID: | a0a6a902cdf1112e73c29df0d31458becfbf793d.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2024-09-20 20:19:46 | pgsql: Doc: update 17.0 release date. |
| Previous Message | Nathan Bossart | 2024-09-20 20:18:58 | pgsql: Alphabetize #include directives in pg_checksums.c. |