Connection::$postgresqlConditionOperatorMap

A map of condition operators to PostgreSQL operators.

In PostgreSQL, 'LIKE' is case-sensitive. ILIKE should be used for case-insensitive statements. PostgreSQL doesn't automatically cast fields to the right type for these operators, so the fields are cast to text.

Type: string[][]

File

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

Class

Connection

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

Namespace

Code

protected static $postgresqlConditionOperatorMap = [
  'LIKE' => [
    'operator' => 'ILIKE',
    'field_suffix' => '::text',
  ],
  'LIKE BINARY' => [
    'operator' => 'LIKE',
    'field_suffix' => '::text',
  ],
  'NOT LIKE' => [
    'operator' => 'NOT ILIKE',
    'field_suffix' => '::text',
  ],
  'REGEXP' => [
    'operator' => '~*',
    'field_suffix' => '::text',
  ],
  'NOT REGEXP' => [
    'operator' => '!~*',
    'field_suffix' => '::text',
  ],
  // Identity entries, so that conditions built with PostgreSQL operators
  // directly also get the field cast. For example, Views' StringFilter
  // maps 'LIKE' to 'ILIKE' itself before adding the condition.
'ILIKE' => [
    'operator' => 'ILIKE',
    'field_suffix' => '::text',
  ],
  'NOT ILIKE' => [
    'operator' => 'NOT ILIKE',
    'field_suffix' => '::text',
  ],
  '~*' => [
    'operator' => '~*',
    'field_suffix' => '::text',
  ],
  '!~*' => [
    'operator' => '!~*',
    'field_suffix' => '::text',
  ],
];