Обсуждение: pgsql: Full Text Search support for json and jsonb

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

pgsql: Full Text Search support for json and jsonb

От
Andrew Dunstan
Дата:
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
Дата:
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


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

От
Andrew Dunstan
Дата:

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