10 Jul
2001
10 Jul
'01
7:30 p.m.
I am running Postgres 7.1 version of postgres on linux mandrake. I use zope as a front end to postgres using the ZPyGreSQLDA-0-0-3 adapter. I would like to have my searches be case insensitive. I got the following out of the user manual: The keyword ILIKE can be used instead of LIKE to make the match case insensitive according to the active locale. This is not in the SQL standard but is a Postgres extension. The operator ~~ is equivalent to LIKE, and ~~* corresponds to ILIKE. There are also !~~ and !~~* operators that represent NOT LIKE and NOT ILIKE. All of these are also Postgres-specific. I tried to use the ILIKE keyword to match my patterns but I was not successfull...a parse error was returned each time.