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 58

Class

Connection

PostgreSQL implementation of <a href="/api/drupal/core%21lib%21Drupal%21Core%21Database%21Connection.php/class/Connection/9" title="Base Database API class." class="local">\Drupal\Core\Database\Connection</a>.

Namespace

Code

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