Re: pgsql: Add json(b)_to_tsvector function

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: pgsql: Add json(b)_to_tsvector function
Дата
Msg-id 6aed7303-8bfd-b1a5-1ae9-50e78749178a@sigaev.ru
обсуждение исходный текст
Ответ на pgsql: Add json(b)_to_tsvector function  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: pgsql: Add json(b)_to_tsvector function  (Andres Freund <andres@anarazel.de>)
Список pgsql-committers
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=desmoxytes&dt=2018-04-07 
18%3A32%3A02

test select_parallel              ... FAILED

I don't understand how it's connected to json_to_tsquery. Can somebody 
point me what I'm missing?

Teodor Sigaev wrote:
> Add json(b)_to_tsvector function
> 
> Jsonb has a complex nature so there isn't best-for-everything way to convert it
> to tsvector for full text search. Current to_tsvector(json(b)) suggests to
> convert only string values, but it's possible to index keys, numerics and even
> booleans value. To solve that json(b)_to_tsvector has a second required
> argument contained a list of desired types of json fields. Second argument is
> a jsonb scalar or array right now with possibility to add new options in a
> future.
> 
> Bump catalog version
> 
> Author: Dmitry Dolgov with some editorization by me
> Reviewed by: Teodor Sigaev
> Discussion: https://www.postgresql.org/message-id/CA+q6zcXJQbS1b4kJ_HeAOoOc=unfnOrUEL=KGgE32QKDww7d8g@mail.gmail.com
> 
> Branch
> ------
> master
> 
> Details
> -------
> https://git.postgresql.org/pg/commitdiff/1c1791e00065f6986f9d44a78ce7c28b2d1322dd
> 
> Modified Files
> --------------
> doc/src/sgml/func.sgml              |  20 ++++
> src/backend/tsearch/to_tsany.c      | 128 ++++++++++++++++++++++----
> src/backend/utils/adt/jsonfuncs.c   | 179 ++++++++++++++++++++++++++++++++----
> src/include/catalog/catversion.h    |   2 +-
> src/include/catalog/pg_proc.h       |  24 +++--
> src/include/utils/jsonapi.h         |  21 ++++-
> src/test/regress/expected/json.out  | 122 ++++++++++++++++++++++++
> src/test/regress/expected/jsonb.out | 122 ++++++++++++++++++++++++
> src/test/regress/sql/json.sql       |  30 ++++++
> src/test/regress/sql/jsonb.sql      |  30 ++++++
> 10 files changed, 629 insertions(+), 49 deletions(-)
> 

-- 
Teodor Sigaev                      E-mail: teodor@sigaev.ru
                                       WWW: http://www.sigaev.ru/


В списке pgsql-committers по дате отправления:

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: pgsql: Make test of json(b)_to_tsvector language-independ
Следующее
От: Andres Freund
Дата:
Сообщение: Re: pgsql: Add json(b)_to_tsvector function