pgsql: Full Text Search support for json and jsonb

Поиск
Список
Период
Сортировка
Искать

pgsql: Full Text Search support for json and jsonb

От:
Andrew 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(+)

Re: pgsql: Full Text Search support for json and jsonb

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Andrew Dunstan  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

Re: pgsql: Full Text Search support for json and jsonb

От:
Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Дата:


On 03/31/2017 02:38 PM, Tom Lane wrote:
> Andrew Dunstan  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


FAQ