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

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

From
Mohammed falih
Date:

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 

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

From
Laurenz Albe
Date:
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



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

From
Mohammed falih
Date:
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:
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