tsearch2: word position - Mailing list pgsql-general

From Markus Schiltknecht
Subject tsearch2: word position
Date
Msg-id 45DC6042.5030005@bluegap.ch
Whole thread Raw
Responses Re: tsearch2: word position  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-general
Hi,

I'm fiddling with to_tsvector() and parse() from tsearch2, trying to get
the word position from those functions. I'd like to use the tsearch2
parser and stemmer, but I need to know the exact position of the word as
well as the original, unstemmed word.

What I came up with so far is pretty ugly:

SELECT
   (parse('my test text')).tokid,
   (parse('my test text')).token,
   strip(to_tsvector((parse('my test text')).token));

And this only tells me a word position, not a character or byte position
within the string. Is there a way to get this information from tsearch2?

Regards

Markus

pgsql-general by date:

Previous
From: Henrik Zagerholm
Date:
Subject: Re: Slow running to_tsvector (tsearch2 in PG 8.2.3)
Next
From: "Michael Nolan"
Date:
Subject: How can you tell if a function is immutable from psql?