[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/