From 3af0b234d2d9d0be8bf578096d621a57eaf3481a Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sat, 6 Aug 2011 06:57:02 -0400 Subject: - Patch #1184082 by googletorp: like queries failing on postgres with standard_conforming_strings() turned on. --- includes/database/pgsql/database.inc | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) (limited to 'includes/database') diff --git a/includes/database/pgsql/database.inc b/includes/database/pgsql/database.inc index 98b954ffd..39b4e9b69 100644 --- a/includes/database/pgsql/database.inc +++ b/includes/database/pgsql/database.inc @@ -145,10 +145,9 @@ class DatabaseConnection_pgsql extends DatabaseConnection { if (!isset($specials)) { $specials = array( // In PostgreSQL, 'LIKE' is case-sensitive. For case-insensitive LIKE - // statements, we need to use ILIKE instead. Use backslash for escaping - // wildcard characters. - 'LIKE' => array('operator' => 'ILIKE', 'postfix' => ' ESCAPE ' . $this->quote("\\")), - 'NOT LIKE' => array('operator' => 'NOT ILIKE', 'postfix' => ' ESCAPE ' . $this->quote("\\")), + // statements, we need to use ILIKE instead. + 'LIKE' => array('operator' => 'ILIKE'), + 'NOT LIKE' => array('operator' => 'NOT ILIKE'), ); } -- cgit v1.2.3