From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com>, Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Tsvector editing functions |
Date: | 2015-10-08 15:11:21 |
Message-ID: | 56168799.6020609@sigaev.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>> There is patch that adds some editing routines for tsvector type.
...
> When submitting a patch, it's a good idea to explain why someone would
> want the feature you are adding. Maybe that's obvious to you, but it
> isn't clear to me why we'd want this.
>
Some examples:
tsvector delete(tsvector, text)
remove wronlgy indexed word (may, be a stop word)
text[] to_array(tsvector)
In my practice, I needed it to work with smlar module.
tsvector to_tsvector(text[])
Converts list of tags to tsvector, because search in tsvector is more
flexible and fast than array's equivalents
set unnest(tsvector)
Count some complicated statistics.
That functions mostly needed in utility processing rather in workflow.
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
From | Date | Subject | |
---|---|---|---|
Next Message | Anastasia Lubennikova | 2015-10-08 15:18:42 | WIP: Covering + unique indexes. |
Previous Message | Alexey Slaykovsky | 2015-10-08 14:43:31 | Windows PostgreSQL and PgAdmin3 Open Source Installers |