Re: contrib/tsearch - word order

On Sun, 22 Jun 2003, Bruce Young wrote:

> I am playing around with contrib/tsearch, but now i am not sure how to
> implement it.
> When i insert words into a txindx column, they are not in the same order after

that's right.

> a select.
> Question is...  is there a way to select text in the order it was inserted or
> do i have to insert a
> duplicate into a varchar/text  column so i can display from the text column
> upon search on the
> txtindx column.
> thanks

You have to use original text anyway ( in separate column or in filesystem)
because txtidx column (tsvector in tsearch v2) not save words order but
also does some preprocessing (stemming, skipping stop words, morphology).

>
>   - bruce
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

    Regards,
        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83