[Zope] Postgres help

Vid B zoops4@yahoo.com
Tue, 10 Jul 2001 09:57:05 -0700 (PDT)


I am using PgSQL 7.0.3, PoPy, and ZPoPyDA, I use ~*
and it gives me insensitive matching.


--- Oleg Broytmann <phd@phd.fep.ru> wrote:
> 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.
> 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
> 
> http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/