Term positions in GIN fulltext index
| От | Yoann Moreau |
|---|---|
| Тема | Term positions in GIN fulltext index |
| Дата | |
| Msg-id | 4EB2B8B7.1060806@univ-avignon.fr обсуждение исходный текст |
| Ответы |
Re: Term positions in GIN fulltext index
Re: Term positions in GIN fulltext index Re: Term positions in GIN fulltext index Re: Term positions in GIN fulltext index |
| Список | pgsql-hackers |
Hello,
I'm using a GIN index for a text column on a big table. I use it to rank
the rows, but I also need to get the term positions for each document of a
subset of documents for one or more terms. I suppose these positions are stored
in the index as the to_tsvector shows them : 'lexeme':{positions}
I've searched and asked on general postgresql mailing list, and I assume
there is no simple way to get these term positions.
For example, for 2 rows of a 'docs' table with a text column 'text' (indexed with GIN) :
'I get lexemes and I get term positions.'
'Did you get the positions ?'
I'd need a function like this :
select term_positions(text, 'get') from docs; id_doc | positions
--------+----------- 1 | {2,6} 2 | {3}
I'd like to add this function in my database, for experimental purpose.
I got a look at the source code but didn't find some code example using the GIN index ;
I can not figure out where the GIN index is read as a tsvector
or where the '@@' operator gets the matching tsvectors for the terms of the tsquery.
Any help about where to start reading would be very welcome :)
Regards,
Yoann Moreau
В списке pgsql-hackers по дате отправления: