On Tuesday, October 20, 2015 7:56 PM, Tim van der Linden <tim@xxxxxxxxx> wrote: > On Tue, 20 Oct 2015 12:02:46 +0100 >> Does the Thesaurus dictionary not do what you want? >> >> http://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-THESAURUS > > Damn, I completely overlooked that one, and it indeed does seem > to come very close to what I need in this use case. I have to admit that the name of that dictionary type threw me off a bit at first. > If I am not mistaken, this would be a valid thesaurus file: > > acute mi : heart attack > mi : heart attack > myocardial infarction : heart attack > > Multiple words on both ends, separated by a colon and each line > being functional (a unique phrase linked to its more generic > replacement)? It has been a while, but my recollection is that I did something more like this: heart attack : heartattack acute mi : heartattack mi : heartattack myocardial infarction : heartattack If my memory is to be trusted, both the original words (whichever are actually in the document) and the "invented" synonym ("heartattack") will be in the tsvector/tsquery; this results in all *matching* but the identical wording being considered a *closer match*. As with most things, I encourage you to play around with it a bit to see what gives the best results for you. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
