RE: Full text search with more than one word

2019-01-25 Thread Ritanjali Majihee
Thanks, Ritanjali From: mag...@hagander.net [mailto:mag...@hagander.net] Sent: Friday, January 18, 2019 8:45 PM To: Ritanjali Majihee Cc: pgsql-general General; Ambiger, Mahantesh; mahantesh.ambi...@yahoo.com Subject: Re: Full text search with more than one word (please don't top-post on

Re: Full text search with more than one word

2019-01-25 Thread Magnus Hagander
t the websearchto_tsquery function. //Magnus > > *From:* mag...@hagander.net [mailto:mag...@hagander.net] > *Sent:* Friday, January 18, 2019 8:45 PM > *To:* Ritanjali Majihee > *Cc:* pgsql-general General; Ambiger, Mahantesh; > mahantesh.ambi...@yahoo.com > *Subject:* Re: Ful

Re: Full text search with more than one word

2019-01-18 Thread Magnus Hagander
(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". > > > >

RE: Full text search with more than one word

2019-01-18 Thread Ritanjali Majihee
help us solve this issue. Thanks, Ritanjali From: mag...@hagander.net [mailto:mag...@hagander.net] Sent: Friday, January 18, 2019 4:11 PM To: Ritanjali Majihee Cc: pgsql-general General; Ambiger, Mahantesh Subject: Re: Full text search with more than one word On Fri, Jan 18, 2019 at

Re: Full text search with more than one word

2019-01-18 Thread Magnus Hagander
On Fri, Jan 18, 2019 at 11:37 AM Ritanjali Majihee < rmaj...@247headhunting.com> wrote: > Hi Team, > > > > We have around 20 millions of records in Postgresql database. One of the > column is html document stored as Text datatype. We want Use this column in > search functionality. We have converte

Full text search with more than one word

2019-01-18 Thread Ritanjali Majihee
Hi Team, We have around 20 millions of records in Postgresql database. One of the column is html document stored as Text datatype. We want Use this column in search functionality. We have converted html content to plaintext and created tokens using to_tsvector. We have implemented full text se