i added Arabic Dictionary but how I know i'm using it

Started by Mohammed falihover 3 years ago3 messagesgeneral
Jump to latest
#1Mohammed falih
moh.falih98@gmail.com

Greetings Dear

I hope you are fine and doing well.

I have a created a dictionary in postgres successfully

but how may I know that I'm using it?

because I'm doing now queries and the results are the same before I
created the dictionary

I downloaded an rar folder that I supposed its a dictionary

i copied a files called th_ar.dat and ar.aff and pasted them in tsearch
folder in postgres folder and renamed them as the_ar.dict and th_ar.affix

as the documentation in postgres told me

https://www.postgresql.org/docs/current/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY

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

so my questions are

1)is there anything I should do before do the query to use the dictionary?

2) is there any chance that I'm doing something wrong ? please mention them?

3) how i know that the dictionary I'm using is correct ?

thank you for your efforts

my best regards

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Mohammed falih (#1)
Re: i added Arabic Dictionary but how I know i'm using it

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

#3Mohammed falih
moh.falih98@gmail.com
In reply to: Laurenz Albe (#2)
Re: i added Arabic Dictionary but how I know i'm using it

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.albe@cybertec.at> wrote:

Show quoted text

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