granicus.if.org Git - postgresql/commit

]> granicus.if.org Git - postgresql/commit

author	Teodor Sigaev <teodor@sigaev.ru>
	Tue, 3 Apr 2018 16:46:45 +0000 (19:46 +0300)
committer	Teodor Sigaev <teodor@sigaev.ru>
	Tue, 3 Apr 2018 16:46:45 +0000 (19:46 +0300)
commit	710d90da1fd8c1d028215ecaf7402062079e99e9
tree	6fb5d284edb7a9c37e3ae633c92779a65d1b97c6	tree \| snapshot
parent	4ab299981576ca0f3dbb879b5e2b704e743d87f3	commit \| diff

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

14 files changed:

Unnamed repository; edit this file 'description' to name the repository.

RSS Atom

doc/src/sgml/func.sgml		diff \| blob \| history
doc/src/sgml/spgist.sgml		diff \| blob \| history
src/backend/access/spgist/spgtextproc.c		diff \| blob \| history
src/backend/utils/adt/selfuncs.c		diff \| blob \| history
src/backend/utils/adt/varlena.c		diff \| blob \| history
src/include/access/stratnum.h		diff \| blob \| history
src/include/catalog/catversion.h		diff \| blob \| history
src/include/catalog/pg_amop.h		diff \| blob \| history
src/include/catalog/pg_operator.h		diff \| blob \| history
src/include/catalog/pg_proc.h		diff \| blob \| history
src/include/utils/selfuncs.h		diff \| blob \| history
src/test/regress/expected/create_index.out		diff \| blob \| history
src/test/regress/expected/opr_sanity.out		diff \| blob \| history
src/test/regress/sql/create_index.sql		diff \| blob \| history