Functions / Json Functions And Operators

jsonb_path_query_first

Returns the first JSON item returned by the JSON path for the specified JSON value, or NULL if there are no results.

Reading PG 18current·documented in 9 of 27 versions, 12 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

jsonb_path_query_first ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → jsonb

Returns the first JSON item returned by the JSON path for the specified JSON value, or NULL if there are no results. The parameters are the same as for jsonb_path_query.

jsonb_path_query_first('{"a":[1,2,3,4,5]}', '$.a[*] ? (@ >= $min && @ <= $max)', '{"min":2, "max":4}') → 2

Version history 3

16 → 17 changed
12 → 13 changed
11 → 12 added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source