diff options
| author | Dries Buytaert <dries@buytaert.net> | 2011-08-06 06:57:02 -0400 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2011-08-06 06:57:07 -0400 |
| commit | 3af0b234d2d9d0be8bf578096d621a57eaf3481a (patch) | |
| tree | f48413739492961b71a7d56d999075fba4d11596 /includes/database/pgsql | |
| parent | 05030fd9408776129cc896b979ac3295b6ee2a0c (diff) | |
| download | brdo-3af0b234d2d9d0be8bf578096d621a57eaf3481a.tar.gz brdo-3af0b234d2d9d0be8bf578096d621a57eaf3481a.tar.bz2 | |
- Patch #1184082 by googletorp: like queries failing on postgres with standard_conforming_strings() turned on.
Diffstat (limited to 'includes/database/pgsql')
| -rw-r--r-- | includes/database/pgsql/database.inc | 7 |
1 files changed, 3 insertions, 4 deletions
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'), ); } |