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: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]