From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | Bruce Young <hbrucey(at)yahoo(dot)com> |
Cc: | PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: contrib/tsearch - word order |
Date: | 2003-06-23 08:31:21 |
Message-ID: | Pine.GSO.4.56.0306231227520.2602@ra.sai.msu.su |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
From | Date | Subject | |
---|---|---|---|
Next Message | utomo restu | 2003-06-23 09:26:33 | About remote synchronization for postgresql |
Previous Message | Bruce Young | 2003-06-23 04:27:17 | contrib/tsearch - word order |