Re: Finally tsearch works ... somehow... remain a few

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема Re: Finally tsearch works ... somehow... remain a few
Дата
Msg-id Pine.GSO.4.58.0408191839200.29483@ra.sai.msu.su
обсуждение исходный текст
Ответ на Finally tsearch works ... somehow... remain a few questions  (Marcel Boscher <mboscher@emedia-office.de>)
Ответы Re: Finally tsearch works ... somehow... remain a few  (Gaetano Mendola <mendola@bigfoot.com>)
Список pgsql-general
Marcel,

On Thu, 19 Aug 2004, Marcel Boscher wrote:

> For now i am almost statisfied with my tsearch2  installation war over night
> somehow it seems to work, finally...

what problems with installation ? Any additions,corrections to docs ?

>
> 3 probably easy questions remain...
> 1.) Is it possible to index already filled tables?

sure. It's written many times.  Check to_tsvector() function

> 2.)Can i have seperated indexes for different columns in a table

why not, you may have separate indices or one index with different
weights assigned to each column (up tp 4 columns)


> 3.) Can i create an extra Table just for my indexes that is not included
> in my data table?

I don't understand this. Example, please.

Seems, you need to reread  documentation.

http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html
http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_Notes

>
> Greetings
> Marcel
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: libpq: passwords WAS: scripting & psql issues
Следующее
От: Adam Ruth
Дата:
Сообщение: Re: Postgresql feature