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