Connection::$postgresqlConditionOperatorMap

Same name and namespace in other branches
  1. 9 core/modules/pgsql/src/Driver/Database/pgsql/Connection.php \Drupal\pgsql\Driver\Database\pgsql\Connection::postgresqlConditionOperatorMap
  2. 8.9.x core/lib/Drupal/Core/Database/Driver/pgsql/Connection.php \Drupal\Core\Database\Driver\pgsql\Connection::postgresqlConditionOperatorMap
  3. 11.x core/modules/pgsql/src/Driver/Database/pgsql/Connection.php \Drupal\pgsql\Driver\Database\pgsql\Connection::postgresqlConditionOperatorMap

A map of condition operators to PostgreSQL operators.

In PostgreSQL, 'LIKE' is case-sensitive. ILIKE should be used for case-insensitive statements.

Type: postgresqlConditionOperatorMap

File

core/modules/pgsql/src/Driver/Database/pgsql/Connection.php, line 57

Class

Connection
PostgreSQL implementation of \Drupal\Core\Database\Connection.

Namespace

Drupal\pgsql\Driver\Database\pgsql

Code

protected static $postgresqlConditionOperatorMap = [
  'LIKE' => [
    'operator' => 'ILIKE',
  ],
  'LIKE BINARY' => [
    'operator' => 'LIKE',
  ],
  'NOT LIKE' => [
    'operator' => 'NOT ILIKE',
  ],
  'REGEXP' => [
    'operator' => '~*',
  ],
  'NOT REGEXP' => [
    'operator' => '!~*',
  ],
];

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.