Tsearch not searching 'Y'

Поиск
Список
Период
Сортировка
От sandeep prakash dhumale
Тема Tsearch not searching 'Y'
Дата
Msg-id 20100429131340.25498.qmail@f4mail-235-146.rediffmail.com
обсуждение исходный текст
Ответы Re: Tsearch not searching 'Y'
Re: Tsearch not searching 'Y'
Список pgsql-sql
Hello All,

I am trying to get tsearch working for my application but I am facing a
problem when alphabet 'Y' is the in the tsquery.

can anyone please share some light on it.


# SELECT 'hollywood'::tsvector @@ to_tsquery('holly:*');
?column?
----------
f
(1 row)

SELECT 'hollywood'::tsvector @@ to_tsquery('holl:*');
?column?
----------
t
(1 row)


It works when i put <> in y as below but i don't want to do it that way.

SELECT 'hollywood'::tsvector @@ to_tsquery('holl<y>:*');
?column?
----------
t

Thanks in advance

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