PostGres Text Search

Started by Nonamealmost 18 years ago2 messagesgeneral
Jump to latest
#1Noname
chrisr@hawaii.rr.com

Hello,

I have been trying to configure the 8.3 text search capabilities using the documentation from the site from section 12 of 8.3 documentation. I understand the basics but I am trying to set up a custom synonym dictionary so that I could have abbreviations be returned as a hit for searches on words that are part of the abbreviation.

For instance if I have the abbreviation "HLA", I would want it to be hit for a search on any of the terms "high", "level", or "architecture" or any combination thereof. Now from the documentation they have a sample synonym dictionary file that contains something like:

postgres pg
postgresql pg
postgre pg

and this will return 'pg' as the lexeme for any of those terms, however, what I want to do is go the other way, and have one term return hits for several terms, but I'm not sure If i can make this work with a synonym dictionary or not.

Should I be attempting this with a synonym dictionary or not, and if not, what approach should i use to accomplish this? I have read through the documentation several times and attempted all the samples, but I may have missed an example of this or have failed to make the connection on how to accomplish this, so if it is merely a matter of my missing the proper reference, a pointer to that would be greatly appreciated as well.

Thanks,

Chris

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: PostGres Text Search

<chrisr@hawaii.rr.com> writes:

For instance if I have the abbreviation "HLA", I would want it to be hit for a search on any of the terms "high", "level", or "architecture" or any combination thereof. Now from the documentation they have a sample synonym dictionary file that contains something like:

postgres pg
postgresql pg
postgre pg

and this will return 'pg' as the lexeme for any of those terms, however, what I want to do is go the other way, and have one term return hits for several terms, but I'm not sure If i can make this work with a synonym dictionary or not.

Synonym translates one word to one other word, so it won't help you
here. You could use the contrib/dict_xsyn module, which does exactly
what you suggest. Or if you want to stick to features that are in core,
the thesaurus dictionary would do, though it seems to be a bit more
complicated to set up.

regards, tom lane