Re: Tsvector editing functions

Поиск
Список
Период
Сортировка
От Stas Kelvich
Тема Re: Tsvector editing functions
Дата
Msg-id 00176BED-A24D-4079-8873-60873F9EC65E@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Tsvector editing functions  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: Tsvector editing functions  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
Hello.

Done with the list of suggestions. Also heavily edit delete function.


---
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company

> On 27 Nov 2015, at 15:13, Teodor Sigaev <teodor@sigaev.ru> wrote:
>
> Hmm, seems, it will be useful to add two fuctions:
>
> tsvector filter(tsvector, array_of_weigths) - returns tsvector contains lexemes with given weights
>
> tsvector setweight(tsvector, weigth, array_of_lexemes) - sets given weight for given lexemes
>
> Stas Kelvich wrote:
>> Hello.
>>
>> There is patch that adds some editing routines for tsvector type.
>>
>> tsvector delete(tsvector, text)
>>     removes entry from tsvector by lexeme name
>> set unnest(tsvector)
>>     expands a tsvector to a set of rows. Each row has following columns: lexeme, postings, weights.
>> text[] to_array(tsvector)
>>     converts tsvector to array of lexemes
>> tsvector to_tsvector(text[])
>>     converts array of lexemes to tsvector
>>
>>
>>
>>
>>
>>
>> Stas Kelvich
>> Postgres Professional: http://www.postgrespro.com
>> The Russian Postgres Company
>>
>>
>>
>>
>>
>
> --
> Teodor Sigaev                                   E-mail: teodor@sigaev.ru
>                                                   WWW: http://www.sigaev.ru/


Вложения

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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: [DOCS] max_worker_processes on the standby
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: pg_receivexlog: spurious error message connecting to 9.3