pgsql: Add prefix operator for TEXT type.

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add prefix operator for TEXT type.
Date: 2018-04-03 16:47:48
Message-ID: E1f3P64-0001lH-Vt@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(dot)222b04b3(at)wp(dot)localdomain

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/710d90da1fd8c1d028215ecaf7402062079e99e9

Modified Files
--------------
doc/src/sgml/func.sgml | 21 +++++++++++++++
doc/src/sgml/spgist.sgml | 1 +
src/backend/access/spgist/spgtextproc.c | 43 +++++++++++++++++++++++++++---
src/backend/utils/adt/selfuncs.c | 33 +++++++++++++++++++++++
src/backend/utils/adt/varlena.c | 28 +++++++++++++++++++
src/include/access/stratnum.h | 3 ++-
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_amop.h | 1 +
src/include/catalog/pg_operator.h | 2 ++
src/include/catalog/pg_proc.h | 5 ++++
src/include/utils/selfuncs.h | 7 +++--
src/test/regress/expected/create_index.out | 38 ++++++++++++++++++++++++++
src/test/regress/expected/opr_sanity.out | 4 ++-
src/test/regress/sql/create_index.sql | 10 +++++++
14 files changed, 189 insertions(+), 9 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2018-04-03 17:13:56 Re: pgsql: Validate page level checksums in base backups
Previous Message Peter Eisentraut 2018-04-03 15:39:56 Re: pgsql: Add Bloom filter implementation.