Thread: pgsql: Full Text Search support for json and jsonb
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(+)
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
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