Functions / Json Functions And Operators

JSON_EXISTS

Returns true if the SQL/JSON path_expression applied to the context_item yields any items, false otherwise.

Reading PG 18current·documented in 4 of 27 versions, 17 to 20

Signatures & examples

JSON_EXISTS ( context_item, path_expression [PASSING { value AS varname } [, ...]] [{ TRUE | FALSE | UNKNOWN | ERROR } ON ERROR]) → boolean

Returns true if the SQL/JSON path_expression applied to the context_item yields any items, false otherwise.

Version history 1

Definition snapshot: b7bd9cda · English manual source