Re: Tsvector editing functions

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org, Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>
Subject: Re: Tsvector editing functions
Date: 2015-11-27 12:13:44
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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:
> The Russian Postgres Company

Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2015-11-27 12:35:06 Re: silent data loss with ext4 / all current versions
Previous Message Teodor Sigaev 2015-11-27 11:38:26 Re: Tsvector editing functions