ts_count

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: ts_count
Date: 2011-06-04 12:47:02
Message-ID: 4DEA2946.3040109@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2011-06-04 13:11:52 Re: creating CHECK constraints as NOT VALID
Previous Message Merlin Moncure 2011-06-04 12:45:50 Re: Error in PQsetvalue