@>(anymultirange,anyelement)

contains

Reading PG 18·Select a recorded version

Left operand: anymultirange
Right operand: anyelement
Result type: bool
Implementing function: multirange_contains_elem(anymultirange,anyelement)
Operator kind: Binary
Hash join candidate: no
Merge join candidate: no
aliases: @>, @>(anymultirange,anyelement)
manual semantics: Exact operand/result signature matched
signature: @>(anymultirange,anyelement) → bool
source oid: 2869

Definition PG 18

contains

Declared operator-family membership

Index AM	Family	Strategy	Purpose	Ordering family
GiST	multirange_ops	16	search

Compare versions

Complete source facts

memberships

map[description:contains family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:@>(anymultirange,anyelement) operator_slug:op-403e-anymultirange-anyelement purpose:search result_type:bool right_type:anyelement sort_family: sort_family_slug: strategy:16]

operator

{"commutator":"\u003c@(anyelement,anymultirange)","function":"multirange_contains_elem(anymultirange,anyelement)","hash_join":"f","kind":"b","left_type":"anymultirange","merge_join":"f","negator":"","result_type":"bool","right_type":"anyelement","symbol":"@\u003e"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f