Wiki / Operators / Internal and special-purpose

@>(_aclitem,aclitem)

contains

Reading PostgreSQL 18.6.

Description

contains

Left operand: _aclitem
Right operand: aclitem
Result type: bool
Implementing function: aclcontains(_aclitem,aclitem)
Operator kind: Binary
Hash join candidate: no
Merge join candidate: no

Usage

@>(_aclitem,aclitem) → bool

English manual definition

Does array contain the specified privileges? (This is true if there is an array entry that matches the aclitem 's grantee and grantor, and has at least the specified set of privileges.)

'{calvin=r*w/hobbes,hobbes=r*w*/postgres}'::aclitem[] @> 'calvin=r*/hobbes'::aclitem → t

Catalog interpretation

The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.

Related entries

Documentation and source

Source build

Version: 18.6
Build: https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
Source fingerprint: 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Compare versions

PostgreSQL 17 → 18: unchanged.

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

Export JSON · Back to Operators · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.