Horton

Handle equality operator in contrib/pg_trgm

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: 935f6666502250abde8615bc7805a6e5aa05a066
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2020-11-15T05:52:35Z
Releases: 14.0 
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

Files

PathChange+/−
contrib/pg_trgm/expected/pg_trgm.out modified +200 −4
contrib/pg_trgm/Makefile modified +1 −1
contrib/pg_trgm/pg_trgm--1.5--1.6.sql added +10 −0
contrib/pg_trgm/pg_trgm.control modified +1 −1
contrib/pg_trgm/sql/pg_trgm.sql modified +40 −0
contrib/pg_trgm/trgm_gin.c modified +3 −0
contrib/pg_trgm/trgm_gist.c modified +3 −1
contrib/pg_trgm/trgm.h modified +1 −0
doc/src/sgml/pgtrgm.sgml modified +5 −3

Documentation touched

Discussion