[Zope] Postgres help

Reinoud van Leeuwen reinoud@xs4all.nl
Tue, 10 Jul 2001 21:37:54 GMT


On Tue, 10 Jul 2001 11:30:03 -0800, you wrote:

>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.

You can allways work around it by using something like
WHERE UPPER(fieldname) LIKE "%UPPERCASESTRING%"
--=20
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen       reinoud@xs4all.nl
http://www.xs4all.nl/~reinoud
-> when replying to a mailinglist mail, please do  <-
-> *NOT* cc: me as well. If I read the list I will <-
-> recieve the reply as well!                      <-
__________________________________________________