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 <> 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
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 |
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 ? |