@@(jsonb,jsonpath)

jsonpath match

Reading PostgreSQL 18.6.

Description

jsonpath match

Left operand: jsonb
Right operand: jsonpath
Result type: bool
Implementing function: jsonb_path_match_opr(jsonb,jsonpath)
Operator kind: Binary
Hash join candidate: no
Merge join candidate: no

Usage

@@(jsonb,jsonpath) → bool

English manual definition

Returns the result of a JSON path predicate check for the specified JSON value. (This is useful only with predicate check expressions , not SQL-standard JSON path expressions, since it will return NULL if the path result is not a single boolean value.)

'{"a":[1,2,3,4,5]}'::jsonb @@ '$.a[*] > 2' → t

Catalog interpretation

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

Declared operator-family membership

Index AM	Family	Strategy	Purpose	Ordering family
GIN	jsonb_ops	16	search
GIN	jsonb_path_ops	16	search

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 11 → 12: added.

--- PostgreSQL 11
+++ PostgreSQL 12
@@ -1 +1,36 @@
-Not recorded in this version
+{
+  "memberships": [
+    {
+      "family": "jsonb_ops",
+      "left_type": "jsonb",
+      "method": "gin",
+      "operator": "@@(jsonb,jsonpath)",
+      "purpose": "search",
+      "right_type": "jsonpath",
+      "sort_family": "",
+      "strategy": "16"
+    },
+    {
+      "family": "jsonb_path_ops",
+      "left_type": "jsonb",
+      "method": "gin",
+      "operator": "@@(jsonb,jsonpath)",
+      "purpose": "search",
+      "right_type": "jsonpath",
+      "sort_family": "",
+      "strategy": "16"
+    }
+  ],
+  "operator": {
+    "commutator": "",
+    "function": "jsonb_path_match_opr(jsonb,jsonpath)",
+    "hash_join": "f",
+    "kind": "b",
+    "left_type": "jsonb",
+    "merge_join": "f",
+    "negator": "",
+    "result_type": "bool",
+    "right_type": "jsonpath",
+    "symbol": "@@"
+  }
+}

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 12 through 20; the first sample is not necessarily its introduction.