diff options
| author | Angie Byron <webchick@24967.no-reply.drupal.org> | 2009-12-13 18:10:43 +0000 |
|---|---|---|
| committer | Angie Byron <webchick@24967.no-reply.drupal.org> | 2009-12-13 18:10:43 +0000 |
| commit | 82c20e6615aff1caec4b8cae422e6d6f043f1e5e (patch) | |
| tree | f6c7ff60427c85c9e22d8b43d3c03ebece9f29f9 /includes/database/pgsql/database.inc | |
| parent | e5356ea62dbe368532c3d23feed7bd26696453f9 (diff) | |
| download | brdo-82c20e6615aff1caec4b8cae422e6d6f043f1e5e.tar.gz brdo-82c20e6615aff1caec4b8cae422e6d6f043f1e5e.tar.bz2 | |
#654662 by c960657 and Crell: Allow escaping wildcard characters in LIKE queries.
Diffstat (limited to 'includes/database/pgsql/database.inc')
| -rw-r--r-- | includes/database/pgsql/database.inc | 5 |
1 files changed, 3 insertions, 2 deletions
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; |