Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>
> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux