Tsearch not searching 'Y' - Mailing list pgsql-sql

From sandeep prakash dhumale
Subject Tsearch not searching 'Y'
Date
Msg-id 20100429131340.25498.qmail@f4mail-235-146.rediffmail.com
Whole thread Raw
Responses Re: Tsearch not searching 'Y'
Re: Tsearch not searching 'Y'
List 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 by date:

Previous
From: Justin Graf
Date:
Subject: Re: [SPAM]-D] How to find broken UTF-8 characters ?
Next
From: Tom Lane
Date:
Subject: Re: Tsearch not searching 'Y'