Reg. Text search.

am 15.09.2009 21:20:39 von Sangaran

This is a multi-part message in MIME format.

------=_NextPart_000_006C_01CA3618.14FBED10
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi

I want to a text search with two words as a single word. For Eg. Business
Analyst. When I convert this into ts_query it convert into 'Business &
Analyst' but it brings up the result as either business as one word matches
and analyst with second matches.

Please let me know whether I need to any other addition in ts_query or
ts_vector

Thanks,

Sangaran

------=_NextPart_000_006C_01CA3618.14FBED10
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

charset=3Dus-ascii">

style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Hi

style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>

style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I want to a text search with two =
words as
a single word. For Eg. Business Analyst. When I convert this into =
ts_query it
convert into ‘Business & Analyst’ but it brings up the =
result
as either business as one word matches and analyst with second =
matches.

style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>

style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Please let me know whether I need =
to any
other addition in ts_query or ts_vector

style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>

style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Thanks,

style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Sangaran >

------=_NextPart_000_006C_01CA3618.14FBED10--