Re: ts_count

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ts_count
Date: 2011-06-04 20:51:19
Message-ID: Pine.LNX.4.64.1106050039330.9772@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Well, there are several functions available around tsearch2. so I suggest
somebody to collect all of them and create one extension - ts_addon.
For example, these are what I remember:
1. tsvector2array
2. noccurences(tsvector, tsquery) - like your ts_count
3. nmatches(tsvector, tsquery) - # of matched lexems in query
Of course, we need to think about better names for functions, since
ts_count is a bit ambiguous.

Oleg

On Sat, 4 Jun 2011, Andrew Dunstan wrote:

>
> One of our PostgreSQL Experts Inc customers wanted a function to count all
> the occurrences of terms in a tsquery in a tsvector. This has been written as
> a loadable module function, and initial testing shows it is working well.
> With the client's permission we are releasing the code - it's available at
> <https://github.com/pgexperts/ts_count>. The actual new code involved here is
> tiny, some of the code is C&P'd from tsrank.c and much of the rest is
> boilerplate.
>
> A snippet from the regression test:
>
>
> select ts_count(to_tsvector('managing managers manage peons
> managerially'),
> to_tsquery('managers | peon'));
> ts_count
> ----------
> 4
>
> We'd like to add something like this for 9.2, so I'd like to get the API
> agreed and then I'll prepare a patch and submit it for the next CF.
>
> Comments? cheers andrew
>
>
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

  • ts_count at 2011-06-04 12:47:02 from Andrew Dunstan

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-06-04 21:49:31 Re: Assert failure when rechecking an exclusion constraint
Previous Message Alvaro Herrera 2011-06-04 18:21:39 Re: creating CHECK constraints as NOT VALID