[Zope] Postgres help

Karl Munroe komunroe@uwimona.edu.jm
Tue, 10 Jul 2001 11:30:03 -0800


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.