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: http://www.postgresql.org/mailpref/pgsql-general
