I have several tables with text columns that contain information that I would like to be able to search using a FTS index. For each text column, there is also a column that is a foreign key into a language table for the language used in the text. My idea is to add a column to the language table to reference a FTS configuration for a given language and to write a function to wrap a call to to_tsvector (after looking up the given configuration name from the language) as per the documentation [http://www.postgresql.org/docs/8.4/interactive/textsearch-tables.html]. However, functions used in indexes must be immutable and while the FTS configuration probably wouldn't change very often for a given language, I suppose it is possible.
My question is: am I better off putting a column in each table with which I want to use FTS to store the FTS config name or can I get away with pushing the FTS configuration name into the language table? Thanks Andrew -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
