Re: TSearch2 / Get all unique lexems - Mailing list pgsql-general

On Wed, 7 Dec 2005, Hannes Dorbath wrote:

> Is there a way to get all unique lexems from a table with a tsvector column?
> The stat() function does this (and more), but I cannot use it..

hmm, you could dump tsvector column and use awk+sort+uniq

>
> Thanks
>
>
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83