tsearch2 and case

Поиск
Список
Период
Сортировка
От Uwe C. Schroeder
Тема tsearch2 and case
Дата
Msg-id 200507041247.35415.uwe@oss4u.com
обсуждение исходный текст
Ответы Re: tsearch2 and case  (Oleg Bartunov <oleg@sai.msu.su>)
Re: tsearch2 and case  (Mike Rylander <mrylander@gmail.com>)
Список pgsql-general
First of all: Happy Independence Day.

I've got a quick question for those with tsearch2 experience.
I set tsearch2 up and it works great (although I'd like to search for phrases
too, but I guess that's not supported at this time).
Anyways, I noted that the search seems to be case sensitive for some search
terms, particularly abbreviations. So if I'm searching with

to_tsquery('ABCD')  - where ABCD is a standard abbreviation, I get a lot of
hits, but I get none with to_tsquery('abcd') because the abbreviation is
always upper case in my text.

I'd like the search to be completely case insensitive. Can anyone point me in
the right direction?

Thanks for any help.

    UC

--
Open Source Solutions 4U, LLC    2570 Fleetwood Drive
Phone:  +1 650 872 2425        San Bruno, CA 94066
Cell:   +1 650 302 2405        United States
Fax:    +1 650 872 2417

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

Предыдущее
От: David Pratt
Дата:
Сообщение: Re: Transparent i18n?
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: Transparent i18n?