Re: tsearch2: How to use different configurations for two columns? - Mailing list pgsql-general

From Andrew J. Kopciuch
Subject Re: tsearch2: How to use different configurations for two columns?
Date
Msg-id 200512090913.45897.akopciuch@bddf.ca
Whole thread Raw
In response to tsearch2: How to use different configurations for two columns?  (Stephan Vollmer <svollmer@gmx.de>)
Responses Re: tsearch2: How to use different configurations for two columns?
List pgsql-general
>
> The configuration seems to work fine, but I can't get tsearch2 to
> use the 'author' config for column 'author_list' and 'default'
> config for column 'title'. Is there any way to accomplish this?
>

It's totally possible.  I don't think you can accomplish this using the simple
tsearch triggers as you declared.  The triggers fire using the configuration
set by curcfg() or will search for the one matching your locale.

You could write a one trigger for the table to handle both.

So you would have one custom function that updates both tsvector columns with
different configurations.


Andy

pgsql-general by date:

Previous
From: Stephan Vollmer
Date:
Subject: tsearch2: How to use different configurations for two columns?
Next
From: Edmund
Date:
Subject: Re: find last day of month