Hello Dear sorry for the late reply your response helped me to finish the feature successfully thank you for your efforts my best regards
On Wed, 17 Aug 2022, 6:59 pm Laurenz Albe, <laurenz.a...@cybertec.at> wrote: > On Wed, 2022-08-17 at 14:33 +0300, Mohammed falih wrote: > > I created the dictionary by this query > > CREATE TEXT SEARCH DICTIONARY arabic_dict ( > > TEMPLATE = ispell, > > DictFile = th_ar, > > AffFile = th_ar, > > Stopwords = arabic); > > and as you know the purpose in dictionary is like when you're searching > for an > > example a "house" the results will also retrieve a records with "home" > because > > it's a synonymous but when I run queries nothing happens > > That would be a "synonym dictionary": > > https://www.postgresql.org/docs/current/textsearch-dictionaries.html#TEXTSEARCH-SYNONYM-DICTIONARY > An Ispell dictionary normalizes words, for example by removing suffixes for > plural and case. > > > You'd have to create a synonym file yourself. > > Yours, > Laurenz Albe >