how about...select .... where translate(lower(myfield), 'âãäåāăąèééêëēĕėęěìíîïìĩīĭóôõöōŏőùúûüũūŭů', 'aaaaaaaeeeeeeeeeeiiiiiiiiooooooouuuuuuu') = 'stringiwannamatch';
or something like that. I may have miscounted the vowells in the 'to' string :)
- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general