Tsearch not searching 'Y'

From: "sandeep prakash dhumale" <sandy9940(at)rediffmail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Tsearch not searching 'Y'
Date: 2010-04-29 13:13:40
Message-ID: 20100429131340.25498.qmail@f4mail-235-146.rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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 &lt;&gt; in y as below but i don't want to do it that way.

SELECT 'hollywood'::tsvector @@ to_tsquery('holl&lt;y&gt;:*');
?column?
----------
t

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jorge Arevalo 2010-04-29 13:21:58 Re: Writing SRF
Previous Message Alban Hertroys 2010-04-29 13:07:55 Re: Performance and Clustering

Browse pgsql-sql by date

  From Date Subject
Next Message Kenneth Marshall 2010-04-29 13:56:02 Re: [SQL] Tsearch not searching 'Y'
Previous Message Justin Graf 2010-04-29 13:05:23 Re: [SPAM]-D] How to find broken UTF-8 characters ?