From 656cf04d5e2f4c777964c5ca8e80546f929b62cc Mon Sep 17 00:00:00 2001
From: Joey Schulze <joey@infodrom.org>
Date: Sat, 21 Dec 2013 22:05:48 +0100
Subject: [PATCH] Support case insensitive query for substrings

---
 lib/dbClass.php | 1 +
 1 file changed, 1 insertion(+)

diff --git a/lib/dbClass.php b/lib/dbClass.php
index 7dab19f..b3a3822 100644
--- a/lib/dbClass.php
+++ b/lib/dbClass.php
@@ -20,6 +20,7 @@ class dbClass_postgresql
   function AffectedRows($rsMain) { return pg_affected_rows($this->conn); }
   function Seek($rsMain,$offset) { return pg_result_seek($rsMain,$offset); }
   function RunParamQuery($query, $phs = array()) {
+    $query = str_replace(' LIKE ?', ' ILIKE ?', $query);
     foreach ($phs as $ph) {   // from php.net
       if ( isset($ph) ) {
         $ph = "'" . pg_escape_string($ph) . "'";
-- 
2.20.1