From a2b3ff76d6d55a6085d44a90bc25858c261b9b43 Mon Sep 17 00:00:00 2001 From: =?utf8?q?S=2E=C3=87a=C4=9Flar=20Onur?= Date: Thu, 22 Jul 2010 16:46:22 -0400 Subject: [PATCH] use ILIKE instead of LIKE for case-insensitive searches --- PLC/Filter.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/PLC/Filter.py b/PLC/Filter.py index 520c6ff..ad412e1 100644 --- a/PLC/Filter.py +++ b/PLC/Filter.py @@ -176,7 +176,7 @@ class Filter(Parameter, dict): value = "NULL" elif isinstance(value, StringTypes) and \ (value.find("*") > -1 or value.find("%") > -1): - operator = "LIKE" + operator = "ILIKE" # insert *** in pattern instead of either * or % # we dont use % as requests are likely to %-expansion later on # actual replacement to % done in PostgreSQL.py -- 2.43.0