changing text search treatment of puncutation

Поиск
Список
Период
Сортировка
От John DeSoi
Тема changing text search treatment of puncutation
Дата
Msg-id 48446333-3ACA-4AAB-8ACB-AEBE17D767E3@pgedit.com
обсуждение исходный текст
Ответы Re: changing text search treatment of puncutation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Text with the '/' character gets treated as a file path, e.g.

select * from to_tsvector('english', 'home/work');

gives only the single token:

'home/work':1

Changing '/' to '-' gives

'home':2 'work':3 'home-work':1

which is much more desirable for this application.

Is there an easy way to change '/' to be treated like '-' ? I've
looked over the documentation several times and could not find
anything. Even just a way to get the two tokens 'home' and 'work'
without the joined form would be helpful.

Thanks,


John DeSoi, Ph.D.





В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Memory use in 8.3 plpgsql with heavy use of xpath()
Следующее
От: Zbigniew Baniewski
Дата:
Сообщение: SET CLIENT_ENCODING