pgsql: Full Text Search support for json and jsonb

Started by Andrew Dunstanabout 9 years ago3 messagescomitters
Jump to latest
#1Andrew Dunstan
andrew@dunslane.net

Full Text Search support for json and jsonb

The new functions are ts_headline() and to_tsvector.

Dmitry Dolgov, edited and documented by me.

Branch
------
master

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

Modified Files
--------------
doc/src/sgml/func.sgml | 18 ++++
src/backend/tsearch/to_tsany.c | 138 ++++++++++++++++++++++++++
src/backend/tsearch/wparser.c | 190 ++++++++++++++++++++++++++++++++++++
src/include/catalog/pg_proc.h | 26 +++++
src/include/tsearch/ts_type.h | 9 ++
src/test/regress/expected/json.out | 90 +++++++++++++++++
src/test/regress/expected/jsonb.out | 90 +++++++++++++++++
src/test/regress/sql/json.sql | 26 +++++
src/test/regress/sql/jsonb.sql | 26 +++++
9 files changed, 613 insertions(+)

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Andrew Dunstan (#1)
Re: pgsql: Full Text Search support for json and jsonb

Andrew Dunstan <andrew@dunslane.net> writes:

Full Text Search support for json and jsonb
The new functions are ts_headline() and to_tsvector.

Should this not have included a catversion bump?

regards, tom lane

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

#3Andrew Dunstan
andrew@dunslane.net
In reply to: Tom Lane (#2)
Re: pgsql: Full Text Search support for json and jsonb

On 03/31/2017 02:38 PM, Tom Lane wrote:

Andrew Dunstan <andrew@dunslane.net> writes:

Full Text Search support for json and jsonb
The new functions are ts_headline() and to_tsvector.

Should this not have included a catversion bump?

Oops, you're right. I see there have been several since then, so no
further action required at this stage.

Thanks also for fixing the regression tests.

cheers

andrew

--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers