Hi,
Is it possible to get all the positions of a lexeme in a result-set of a
query? For example, we have the table
TEXT TEXT_IDX
'TSearch2 is very cool' ...
'It would be much cooler with lexeme positions'
Our query is
SELECT text, position FROM thetable WHERE text_idx @@ 'cool'::tsquery;
^^^^^^^^
The result should be something like:
'TSearch2 is very cool', 4
'It would be much cooler with lexeme positions', 5
If not, is there a function that returns the positions of a lexeme in a
single entry?
thanks
Alex
--
Dipl.-Inform. Alexander Rueegg
Bioinformatics Department Faculty of Technology
Bielefeld University
Phone: +49 (0)521-106-3541
Fax: +49 (0)521-106-6488
Room: C02-206
Email: arueegg@techfak.uni-bielefeld.de