Tsearch 2, index in different table?

Поиск
Список
Период
Сортировка
От Mag Gam
Тема Tsearch 2, index in different table?
Дата
Msg-id 1cbd6f830512220728w41a6e177t9994fbac4c9ec3f0@mail.gmail.com
обсуждение исходный текст
Ответы Re: Tsearch 2, index in different table?  (<operationsengineer1@yahoo.com>)
Список pgsql-novice
Trying this post again, since I can't post on pgsql-general....

Is it possible to store an index in a different table? Instead of
keeping the index in a separate column, I have a separate table for
storing all indexes. I am trying to set up something like this:

UPDATE indexTable SET index1=to_tsvector('default',coalesce(Table1.Data,''));

This is currently not working, but something in this line. Is this
possible? Does tsearch2 only restrict to 1 table?

TIA

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

Предыдущее
От: Volkan YAZICI
Дата:
Сообщение: Re: problem with nasty latin2 sorting
Следующее
От: Tim Baumgartner
Дата:
Сообщение: long transaction with concurrent SELECT statements