tsearch2: index in different table? - Mailing list pgsql-general

From Mag Gam
Subject tsearch2: index in different table?
Date
Msg-id 1cbd6f830512200950l106090aepe2b7d016f0b379a0@mail.gmail.com
Whole thread Raw
List 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-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: out of memory during query execution
Next
From: Klein Balázs
Date:
Subject: recursive function