From: Tom Lane <tgl@sss.pgh.pa.us>
To: sandeep prakash dhumale <sandy9940@rediffmail.com>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: Tsearch not searching 'Y'
Date: Thu, 29 Apr 2010 10:01:31 -0400
Message-ID: <10739.1272549691@sss.pgh.pa.us> (raw)
In-Reply-To: <20100429131340.25498.qmail@f4mail-235-146.rediffmail.com>
References: <20100429131340.25498.qmail@f4mail-235-146.rediffmail.com>
"sandeep prakash dhumale" <sandy9940@rediffmail.com> writes:
> I am trying to get tsearch working for my application but I am facing a
> problem when alphabet 'Y' is the in the tsquery.
> # SELECT 'hollywood'::tsvector @@ to_tsquery('holly:*');
> ?column?
> ----------
> f
> (1 row)
You can't use to_tsquery for this sort of thing, because it tries to
normalize the given words:
regression=# select to_tsquery('holly:*');
to_tsquery
------------
'holli':*
(1 row)
If you do this it works:
regression=# SELECT 'hollywood'::tsvector @@ 'holly:*'::tsquery;
?column?
----------
t
(1 row)
So if you want to use prefix matching, don't normalize.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, sandy9940@rediffmail.com, pgsql-general@postgresql.org
Subject: Re: Tsearch not searching 'Y'
In-Reply-To: <10739.1272549691@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox