Thread: tsearch2: index in different table?

tsearch2: index in different table?

From

Mag Gam

Date:

20 December 2005, 16:50:54

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