Handle equality operator in contrib/pg_trgm
authorAlexander Korotkov <akorotkov@postgresql.org>
Sun, 15 Nov 2020 05:52:12 +0000 (08:52 +0300)
committerAlexander Korotkov <akorotkov@postgresql.org>
Sun, 15 Nov 2020 05:52:35 +0000 (08:52 +0300)
commit935f6666502250abde8615bc7805a6e5aa05a066
tree7a7d841a385fa0c310061a5b45f95af4965e0598
parent92bf7e2d027466d750b4ac5b026f6f4ac29be881
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
contrib/pg_trgm/Makefile
contrib/pg_trgm/expected/pg_trgm.out
contrib/pg_trgm/pg_trgm--1.5--1.6.sql [new file with mode: 0644]
contrib/pg_trgm/pg_trgm.control
contrib/pg_trgm/sql/pg_trgm.sql
contrib/pg_trgm/trgm.h
contrib/pg_trgm/trgm_gin.c
contrib/pg_trgm/trgm_gist.c
doc/src/sgml/pgtrgm.sgml