Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 234A0633508 for ; Thu, 29 Apr 2010 10:26:00 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 11887-07 for ; Thu, 29 Apr 2010 13:25:45 +0000 (UTC) X-Greylist: delayed 00:06:38.263491 by SQLgrey-1.7.6 Received: from rediffmail.com (f4mail-235-146.rediffmail.com [202.137.235.146]) by mail.postgresql.org (Postfix) with SMTP id 74FDA63347C for ; Thu, 29 Apr 2010 10:25:43 -0300 (ADT) Received: (qmail 25506 invoked by uid 510); 29 Apr 2010 13:13:40 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=redf; d=rediffmail.com; b=Lk9zsxc0f7qSvwaBqea5Tax1pe/ADZpTZaAx4U+dv7sIGNBjoHi0XojkVyF29hr4YJsIwtFbSPqpaZJvGLthrvgt2mLbxPGV9MAStX5IesZoP1WrDPjA/dtoRCeZ8hR+wKcui3Hp/7KqAxd00MlTM3Y2Z9x2wHBnR0etq+Y1qos= ; X-CTCH-Spam: Unknown X-CTCH-VOD: Unknown X-CTCH-Flags: : 0 X-CTCH-RefID: str=0001.0A150203.4BD98745.0069,ss=1,fgs=0 Date: 29 Apr 2010 13:13:40 -0000 Message-ID: <20100429131340.25498.qmail@f4mail-235-146.rediffmail.com> MIME-Version: 1.0 To: , Received: from unknown 59.163.11.66 by rediffmail.com via HTTP; 29 Apr 2010 13:13:39 -0000 Subject: =?utf-8?B?VHNlYXJjaCBub3Qgc2VhcmNoaW5nICdZJw==?= From: "sandeep prakash dhumale" Content-Type: multipart/alternative; boundary="=_d1e08d0059852f3e816504096240898a" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.407 tagged_above=-10 required=5 tests=BAYES_50=0.8, FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001, HTML_IMAGE_ONLY_12=2.059, HTML_MESSAGE=0.001, HTML_SHORT_LINK_IMG_1=0.001, MSGID_FROM_MTA_HEADER=0.001, T_RP_MATCHES_RCVD=-0.01, UNPARSEABLE_RELAY=0.001 X-Spam-Level: **** X-Archive-Number: 201004/1069 X-Sequence-Number: 162267 --=_d1e08d0059852f3e816504096240898a Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="UTF-8" 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 --=_d1e08d0059852f3e816504096240898a Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="UTF-8"

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 ts=
query.

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.

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

Thanks in advance

--=_d1e08d0059852f3e816504096240898a--