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

Поиск
Список
Период
Сортировка
От Andrew J. Kopciuch
Тема Re: tsearch2: How to use different configurations for two columns?
Дата
Msg-id 200512090913.45897.akopciuch@bddf.ca
обсуждение исходный текст
Ответ на tsearch2: How to use different configurations for two columns?  (Stephan Vollmer <svollmer@gmx.de>)
Ответы Re: tsearch2: How to use different configurations for two columns?  ("Andrew J. Kopciuch" <akopciuch@bddf.ca>)
Список 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 по дате отправления:

Предыдущее
От: Stephan Vollmer
Дата:
Сообщение: tsearch2: How to use different configurations for two columns?
Следующее
От: Edmund
Дата:
Сообщение: Re: find last day of month