pgsql: Phrase full text search.

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Phrase full text search.
Date: 2016-04-07 15:58:14
Message-ID: E1aoCJy-0004bp-HI@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Phrase full text search.

Patch introduces new text search operator (<-> or <DISTANCE>) 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

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/bb140506df605fab58f48926ee1db1f80bdafb59

Modified Files
--------------
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(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Kevin Grittner 2016-04-07 16:14:02 pgsql: Detect SSI conflicts before reporting constraint violations
Previous Message Peter Eisentraut 2016-04-07 15:57:30 Re: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.