Thread: Full-text Search - Thesaurus relationships

Hi,

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
them ?

Thanks,


[1]: https://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS
-- 
nicolas

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
> them ?

No, it should happen automatically.

Essentially, it is an extended synonym dictionary, and if you specify it
for a certain token type in your text search configuration, it will replace
certain phrases with something else.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

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 keyword to and associated syntax to make use of
> > them ?
> No, it should happen automatically.

If "broader than" or "narrower than" have the same behavior than "is
equivalent to" I cannot figure out what's the purpose of them.

-- 
nicolas

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
> > > them ?
> 
> If "broader than" or "narrower than" have the same behavior than "is
> equivalent to" I cannot figure out what's the purpose of them.

Can you come up with a clear question?

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

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 in
> > > > postgres. Is there any keyword to and associated syntax to make use of
> > > > them ?
> > 
> > If "broader than" or "narrower than" have the same behavior than "is
> > equivalent to" I cannot figure out what's the purpose of them.
> Can you come up with a clear question?

Actually no because I finally understood the behavior. 

Thanks,

-- 
nicolas