On Thu, Nov 3, 2011 at 4:52 PM, Yoann Moreau
<yoann(dot)moreau(at)univ-avignon(dot)fr> wrote:
> I'd need a function like this :
> select term_positions(text, 'get') from docs;
> id_doc | positions
> --------+-----------
> 1 | {2,6}
> 2 | {3}
>
check this out:
http://www.postgresql.org/docs/current/static/textsearch-debugging.html
ts_debug does what You want, and more. Look at it's source - it`s a
plain sql function, You can make something based on it.
Greetings
Marcin Mańk