Phrase full text search

Enterprise / PostgreSQL - Teodor Sigaev [sigaev.ru] - 7 April 2016 10:44 UTC

Patch introduces new text search operator (<-> or ) into tsquery. On-disk and binary in/out format of tsquery are backward compatible. It has two side effect:- change order for tsquery, so, users, who has a btree index over tsquery, should reindex it- less number of parenthesis in tsquery output, and tsquery becomes more readable

Authors: Teodor Sigaev, Oleg Bartunov, Dmitry Ivanov Reviewers: Alexander Korotkov, Artur Zakirov

bb14050 Phrase full text search.
contrib/tsearch2/expected/tsearch2.out | 56 ++---
doc/src/sgml/datatype.sgml | 9 +-
doc/src/sgml/func.sgml | 39 +++
doc/src/sgml/textsearch.sgml | 182 +++++++++++++-
src/backend/tsearch/to_tsany.c | 187 ++++++++-------
src/backend/tsearch/ts_parse.c | 15 +-
src/backend/tsearch/ts_selfuncs.c | 3 +-
src/backend/tsearch/wparser_def.c | 31 ++-
src/backend/utils/adt/tsginidx.c | 57 +++--
src/backend/utils/adt/tsgistidx.c | 4 +-
src/backend/utils/adt/tsquery.c | 311 ++++++++++++++++++------
src/backend/utils/adt/tsquery_cleanup.c | 362 ++++++++++++++++++++++++++--
src/backend/utils/adt/tsquery_op.c | 54 ++++-
src/backend/utils/adt/tsquery_util.c | 11 +-
src/backend/utils/adt/tsrank.c | 263 ++++++++++++++------
src/backend/utils/adt/tsvector.c | 2 +-
src/backend/utils/adt/tsvector_op.c | 326 ++++++++++++++++++++++---
src/backend/utils/adt/tsvector_parser.c | 10 +-
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_operator.h | 3 +
src/include/catalog/pg_proc.h | 7 +
src/include/tsearch/ts_public.h | 22 +-
src/include/tsearch/ts_type.h | 30 ++-
src/include/tsearch/ts_utils.h | 15 +-
src/test/regress/expected/tsdicts.out | 36 ++-
src/test/regress/expected/tsearch.out | 395 ++++++++++++++++++++++++++++---
src/test/regress/expected/tstypes.out | 369 ++++++++++++++++++++++++++++-
src/test/regress/sql/tsdicts.sql | 3 +
src/test/regress/sql/tsearch.sql | 101 ++++++++
src/test/regress/sql/tstypes.sql | 75 +++++-
30 files changed, 2536 insertions(+), 444 deletions(-)

Upstream: git.postgresql.org

  • Share