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.
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.
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/
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%" -- __________________________________________________ "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! <- __________________________________________________
participants (4)
-
Karl Munroe -
Oleg Broytmann -
reinoud＠xs4all.nl -
Vid B