Re: Full text search - wildcard and a stop word

2022-02-22 Thread Tom Lane
Allan Jardine writes: > => select to_tsquery('all:*'); > NOTICE: text-search query contains only stop words or doesn't contain > lexemes, ignored > to_tsquery > > (1 row) > I get why that is happening - the notification basically details it, but > the wildcard at the end seems to m

Re: full text

2020-04-09 Thread Stephen Frost
Greetings, * Roberto Della Pasqua (roberto.dellapas...@live.com) wrote: > Please sorry because I'm newbie of PGSQL We all were, once upon a time. :) > I need the best performing and overall quality full-text search, can be > possible to have the data stored in pgsql and the index to elasticsear

Re: full text

2020-04-09 Thread Martin Gainty
i dont know how to do with elastic-search according to programcreek you can create an index from a jdbc source https://www.programcreek.com/java-api-examples/?code=SeldonIO/semantic-vectors-lucene-tools/semantic-vectors-lucene-tools-master/src/main/java/io/seldon/semvec/CreateLuceneIndexFromDb.j

Re: full text

2020-04-08 Thread Joshua Drake
Roberto, I would look at ZomboDB: https://www.zombodb.com/ . Which is exactly what you suggest. JD On Wed, Apr 8, 2020 at 10:28 AM Roberto Della Pasqua < roberto.dellapas...@live.com> wrote: > Please sorry because I’m newbie of PGSQL > > > > I need the best performing and overall quality full-t

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

Re: Full-text Search - Thesaurus relationships

2018-10-31 Thread Nicolas Paris
On Wed, Oct 31, 2018 at 10:49:04AM +0100, Laurenz Albe wrote: > Nicolas Paris wrote: > > > > The documentation[1] says thesaurus can include informations of terms > > > > relationships such broader terms, preferred terms ... > > > > I haven't been able to find out how to exploit those relationship

Re: Full-text Search - Thesaurus relationships

2018-10-31 Thread Laurenz Albe
Nicolas Paris wrote: > > > The documentation[1] says thesaurus can include informations of terms > > > relationships such broader terms, preferred terms ... > > > I haven't been able to find out how to exploit those relationship in > > > postgres. Is there any keyword to and associated syntax to ma

Re: Full-text Search - Thesaurus relationships

2018-10-31 Thread Nicolas Paris
On Wed, Oct 31, 2018 at 07:56:28AM +0100, Laurenz Albe wrote: > > The documentation[1] says thesaurus can include informations of terms > > relationships such broader terms, preferred terms ... > > I haven't been able to find out how to exploit those relationship in > > postgres. Is there any keywo

Re: Full-text Search - Thesaurus relationships

2018-10-30 Thread Laurenz Albe
Nicolas Paris wrote: > The documentation[1] says thesaurus can include informations of terms > relationships such broader terms, preferred terms ... > > I haven't been able to find out how to exploit those relationship in > postgres. Is there any keyword to and associated syntax to make use of >