Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 5F89512DEACC
	for <pgsql-admin@postgresql.org>; Mon, 23 Apr 2012 14:13:18 -0300 (ADT)
Received: from nm26.bullet.mail.bf1.yahoo.com ([98.139.212.185])
	by magus.postgresql.org with smtp (Exim 4.72)
	(envelope-from <s5aly@yahoo.com>) id 1SMMp9-0001uv-HB
	for pgsql-admin@postgresql.org; Mon, 23 Apr 2012 17:13:17 +0000
Received: from [98.139.212.152] by nm26.bullet.mail.bf1.yahoo.com with NNFMP;
	23 Apr 2012 17:10:11 -0000
Received: from [98.139.212.226] by tm9.bullet.mail.bf1.yahoo.com with NNFMP;
	23 Apr 2012 17:10:11 -0000
Received: from [127.0.0.1] by omp1035.mail.bf1.yahoo.com with NNFMP;
	23 Apr 2012 17:10:11 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 85536.93117.bm@omp1035.mail.bf1.yahoo.com
Received: (qmail 37150 invoked by uid 60001); 23 Apr 2012 17:10:11 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1335201011; bh=ABEow3qGtmbSoEZfsIWzUBYPwmPpXmx63Ocldis4Teg=;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=z6+iKO63p5cDllb6B/1DfbTjU30EV9LAgIeXnP93cuJCwYxugaJS8cmI2zCaOvhPzh18fW7kyoTCb2Wv+VWWSyaDkek3Q4jUFIJ45z0akYrWrTUgQbz0bmcul8dszLrjaCDuSWgKz/qjbe/H/IJr2L+hK5nWuT1jBScy5FT7UpY=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=otCGVmQ94Soviu8ZilZc7Wg0V4OZAPIcE78r+7rO9qCbqJC+/UjxrFymUmGlEiuMswnRd2u8qp1/6EGPEmx2PXiVeYNhyjEutlJLNMZtkGLsCGaLl43d6egwIeQznEFY61LcnYUNbn99KpdT32jciDbsDh/hKtl3g4+m3Uq2DoI=;
X-YMail-OSG: D7mRbwwVM1kScuv9UcoiO9w3utUOHIUq_dLQ8MQz0vJOeWd
	OX9h.2RZq4aY2K1dFYVOiSxmyQ36CRgLnBW2H26zORzzIV0ySPJA_X_Bu.lu
	GNhDFa9kaPW3JCYMVlNcRWikBbOiC86XpqTr7mHgVS120Kx6uy7GPt6FNclJ
	R0qBHpt3UZoVcGa0mteLHIVmKqt4AayjHEf7dHCaA57P0dZ0yQUJbzBWi6cm
	VHfjq8fBokzAZRAmcP9W_dWM9oAStl1Qrg4iLeO7amNbsr6FmpmBpWMc8Nf2
	hcJg63uAmOD.ZE_xYfx4n64vY6w9KvQjxAYD.kyEXBGtrmPHsd5IoqQV7QUW
	khJ9WzlWnEf2KtGqqE60pTMvQwQZeXL5aP6Y9AE8t00TcvsGFMOHLadRgEUx
	pAdIgX3GuROQnJnA-
Received: from [64.61.91.74] by web161501.mail.bf1.yahoo.com via HTTP;
	Mon, 23 Apr 2012 10:10:10 PDT
X-Mailer: YahooMailWebService/0.8.117.340979
Message-ID: <1335201010.30117.YahooMailNeo@web161501.mail.bf1.yahoo.com>
Date: Mon, 23 Apr 2012 10:10:10 -0700 (PDT)
From: A J <s5aly@yahoo.com>
Reply-To: A J <s5aly@yahoo.com>
Subject: Partial substrings in FTS
To: PG Admin <pgsql-admin@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="-167995730-1687843934-1335201010=:30117"
X-Pg-Spam-Score: 0.7 (/)
X-Archive-Number: 201204/122
X-Sequence-Number: 39458

---167995730-1687843934-1335201010=:30117
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

In FTS, how do I search for partial substrings that don't form a English wo=
rd.=0AExample, in the text: 'one hundred thirty four'=A0 I want to find the=
 records based on 'hun'=0A=0ASELECT to_tsvector('one hundred thirty four') =
@@ to_tsquery('hun');=0Adoes not return anything.=0A=0AThanks.=0A
---167995730-1687843934-1335201010=:30117
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><body><div style=3D"color:#000; background-color:#fff; font-family:ti=
mes new roman, new york, times, serif;font-size:12pt"><div>In FTS, how do I=
 search for partial substrings that don't form a English word.</div><div>Ex=
ample, in the text: 'one hundred thirty four'&nbsp; I want to find the reco=
rds based on 'hun'</div><div><br></div><div>SELECT to_tsvector('one hundred=
 thirty four') @@ to_tsquery('hun');</div><div>does not return anything.</d=
iv><div><br></div><div>Thanks.<br></div></div></body></html>
---167995730-1687843934-1335201010=:30117--