Tsearch2 lexeme position
От | Alexander Rüegg |
---|---|
Тема | Tsearch2 lexeme position |
Дата | |
Msg-id | 3F3A01A8.1030006@uni-bielefeld.de обсуждение исходный текст |
Ответы |
Re: Tsearch2 lexeme position
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: