On 2009-03-18, cifroes <cifr...@netcabo.pt> wrote:
> This is a multi-part message in MIME format.
> ------_=_NextPart_001_01C9A7E6.B32BBA87
> Content-Type: text/plain;
>       charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
> Hi,
> I have a DB in utf-8 and postgres 8.3.x.=20
> How can I do an accent insensitive search (like ...) ?

use a posix regular expression that matches the string you want:

select * from foo where colname ~ '^[CcĆćĈĉĊċČč][ĀāĂ㥹Aa][Pp][ŌōŎŏŐő]$';

you could write a function to do the translation.

Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:

Reply via email to