Re: search on accents over all possible matches

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Jaume Teixi <teixi(at)6tems(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: search on accents over all possible matches
Date: 2001-03-27 17:24:34
Message-ID: Pine.LNX.4.30.0103271919550.1215-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jaume Teixi writes:

> this c function from Patrice Hédé is the most appropiate tool for
> searching on an accent based language ?
> http://www.postgresql.org/mhonarc/pgsql-sql/1998-06/msg00119.html

Looks good to me.

> or should I use an implemented function inside postgres right now ?

The reason there is no such implementation, and probably won't be any time
soon, is that this tool would either have to hard-code or ignore natural
language semantics, neither of which would make it practical. Not all
languages have the same accent ignoring or accent folding rules or
conventions.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ajob 2001-03-27 17:25:22 User Database Authentication via PHP
Previous Message David Lizano 2001-03-27 17:00:21 Re: search on accents over all possible matches