Re: tsearch2: How to use different configurations for two columns?

From: "Andrew J(dot) Kopciuch" <akopciuch(at)bddf(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: tsearch2: How to use different configurations for two columns?
Date: 2005-12-09 16:13:45
Message-ID: 200512090913.45897.akopciuch@bddf.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2005-12-09 16:22:48 Re: bug or not? Trigger preventing delete causes circumvention
Previous Message Stephan Vollmer 2005-12-09 14:57:49 tsearch2: How to use different configurations for two columns?