From 82c20e6615aff1caec4b8cae422e6d6f043f1e5e Mon Sep 17 00:00:00 2001 From: Angie Byron Date: Sun, 13 Dec 2009 18:10:43 +0000 Subject: #654662 by c960657 and Crell: Allow escaping wildcard characters in LIKE queries. --- includes/database/pgsql/database.inc | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'includes/database/pgsql') diff --git a/includes/database/pgsql/database.inc b/includes/database/pgsql/database.inc index 6772471b6..8b60b957b 100644 --- a/includes/database/pgsql/database.inc +++ b/includes/database/pgsql/database.inc @@ -120,8 +120,9 @@ class DatabaseConnection_pgsql extends DatabaseConnection { public function mapConditionOperator($operator) { static $specials = array( // In PostgreSQL, 'LIKE' is case-sensitive. For case-insensitive LIKE - // statements, we need to use ILIKE instead. - 'LIKE' => array('operator' => 'ILIKE'), + // statements, we need to use ILIKE instead. Use backslash for escaping + // wildcard characters. + 'LIKE' => array('operator' => 'ILIKE', 'postfix' => " ESCAPE '\\\\'"), ); return isset($specials[$operator]) ? $specials[$operator] : NULL; -- cgit v1.2.3