Horton

Add prefix operator for TEXT type.

Teodor Sigaev <teodor@sigaev.ru>

View on postgr.es
Commit: 710d90da1fd8c1d028215ecaf7402062079e99e9
Author: Teodor Sigaev <teodor@sigaev.ru>
Date: 2018-04-03T16:46:45Z
Releases: 11.0 
Add prefix operator for TEXT type.

The prefix operator along with SP-GiST indexes can be used as an alternative
for LIKE 'word%' commands  and it doesn't have a limitation of string/prefix
length as B-Tree has.

Bump catalog version

Author: Ildus Kurbangaliev with some editorization by me
Review by: Arthur Zakirov, Alexander Korotkov, and me
Discussion: https://www.postgresql.org/message-id/flat/20180202180327.222b04b3@wp.localdomain

Files

PathChange+/−
doc/src/sgml/func.sgml modified +21 −0
doc/src/sgml/spgist.sgml modified +1 −0
src/backend/access/spgist/spgtextproc.c modified +39 −4
src/backend/utils/adt/selfuncs.c modified +33 −0
src/backend/utils/adt/varlena.c modified +28 −0
src/include/access/stratnum.h modified +2 −1
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_amop.h modified +1 −0
src/include/catalog/pg_operator.h modified +2 −0
src/include/catalog/pg_proc.h modified +5 −0
src/include/utils/selfuncs.h modified +5 −2
src/test/regress/expected/create_index.out modified +38 −0
src/test/regress/expected/opr_sanity.out modified +3 −1
src/test/regress/sql/create_index.sql modified +10 −0

Documentation touched

Discussion