Hello,

There is a free SQLf plugin for Postgresql developed by a french team (Pilgrim/IRISA) with collaboration with Postgresql french group. It is accessible on "https://github.com/postgresqlf/PostgreSQL_f".

The plugin allows users defining fuzzy predicates such as "cheap", "low", "recent" etc. and using them in SQL statements like :

SELECT DISTINCT make, name, model, price, mileage, year, get_mu() as mu

FROM annoncesauto

WHERE (price ~= 'very cheap') && (mileage ~= 'low') && (age ~= 'recent')

ORDER BY mu DESC LIMIT 15;

The documentation is unfortunately in french but as it is about a technical topic enriched with several SQL examples, its translatation into english would not be so difficult.

I think that this pluging can be a good start to figure out how fuzzy databases work.

Enjoy,

Nouredine.

Thank you so much, that is a good advise, but the link does not work for me (ERROR 404), so I would apreciate it if you can indicate me where should i download that plugin and the documentation. I have a close friend that speaks french (sort of) named google translator and I speak spanish, so i am confortable with romantics langauges. Thank you.

Hello,

The link works well. The problem lies in the redirection implemented by researchgate. So, you can copy the link from the message and paste it in the address bar of you browser, then remove the redirection part and replace special characters (stuff like %3A, %2F, etc.) and voila :-)

Best,

Nouredine.

Hi,

you are right i downloaded it successfully, you are a very kind researcher,

thanks,

fredy