On Sat, 15 Jan 2000, yura wrote:
> We have ported MS Acess database to PostgreSQL. Everything ok, but our
> user are used to search data in tables using filters, and Access does
> case insensitive search, but when working with Postgres database it
> converts filters into queries with 'like' operator. So is there any
> way to make 'like' operator case insensitive? Or maybe somebody has
> the same problems and knows the solution?
take a look at ~= and etc. operators, everything you need is there.
mazek
Marcin Mazurek
--
administrator
MULTINET SA o/Poznan
http://www.multinet.pl/