tsearch2: word position

Поиск
Список
Период
Сортировка
От Markus Schiltknecht
Тема tsearch2: word position
Дата
Msg-id 45DC6042.5030005@bluegap.ch
обсуждение исходный текст
Ответы Re: tsearch2: word position  (Teodor Sigaev <teodor@sigaev.ru>)
Список 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 по дате отправления:

Предыдущее
От: Henrik Zagerholm
Дата:
Сообщение: Re: Slow running to_tsvector (tsearch2 in PG 8.2.3)
Следующее
От: "Michael Nolan"
Дата:
Сообщение: How can you tell if a function is immutable from psql?