Re: Tsvector editing functions

Поиск
Список
Период
Сортировка
Искать
От
Teodor Sigaev
Тема
Re: Tsvector editing functions
Дата
Msg-id
565848F8.9050905@sigaev.ru
Ответ на
Список
Дерево обсуждения
Tsvector editing functions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Tsvector editing functions Teodor Sigaev <teodor@sigaev.ru>
Re: Tsvector editing functions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Tsvector editing functions Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Tsvector editing functions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Tsvector editing functions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Tsvector editing functions Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Tsvector editing functions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Tsvector editing functions Teodor Sigaev <teodor@sigaev.ru>
Re: Tsvector editing functions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Tsvector editing functions Teodor Sigaev <teodor@sigaev.ru>
Re: Tsvector editing functions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Tsvector editing functions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Tsvector editing functions Teodor Sigaev <teodor@sigaev.ru>
Re: Tsvector editing functions Teodor Sigaev <teodor@sigaev.ru>
Re: Tsvector editing functions Michael Paquier <michael.paquier@gmail.com>
Re: Tsvector editing functions Robert Haas <robertmhaas@gmail.com>
Re: Tsvector editing functions Teodor Sigaev <teodor@sigaev.ru>
Re: Tsvector editing functions Teodor Sigaev <teodor@sigaev.ru>
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 по дате отправления
От: Teodor Sigaev
Дата:
Сообщение: Re: Tsvector editing functions
От: Teodor Sigaev
Дата:
FAQ