[Zope] Postgres help

Oleg Broytmann Oleg Broytmann <phd@phd.fep.ru>
Tue, 10 Jul 2001 20:32:28 +0400 (MSD)


On Tue, 10 Jul 2001, Karl Munroe 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.

   Have you tried your query from the commandline (psql)?

Oleg.
----
     Oleg Broytmann     http://www.zope.org/Members/phd/     phd@phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.