(please don't top-post on the postgresql mailinglists)
On Fri, Jan 18, 2019 at 3:57 PM Ritanjali Majihee <rmajhee@xxxxxxxxxxxxxxxxxx> wrote:
Hi Magnus,
exact Search keyword is ("Marketing Coordinator" OR "Marketing Specialist" OR "Marketing Associate" ) AND "Creative Suite".
Where condition like below syntax we are using in Postgresql function
SELECT * from tablename where html_tokens @@ to_tsquery( ' || quote_literal(ikeyword) || ')
From search keyword we are getting result but not as expected .It is not searching together "Marketing Coordinator" string, It is giving result like "Marketing and Coordinator".
Can you please help us solve this issue.
You should look into phraseto_tsquery() for searching for phrases, and websearchto_tsquery() for the kind of complete search with or and and in it that you are looking for. to_tsquery doesn't do any parsing like that.
//Magnus
