(please don't top-post on the postgresql mailinglists) On Fri, Jan 18, 2019 at 3:57 PM Ritanjali Majihee < rmaj...@247headhunting.com> 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