Skip to main content
Version: 4.2.0

jsonb_comparison_exp

Boolean expression to compare columns of type "jsonb". All fields are combined with logical 'AND'.

input jsonb_comparison_exp {
_contained_in: jsonb
_contains: jsonb
_eq: jsonb
_gt: jsonb
_gte: jsonb
_has_key: String
_has_keys_all: [String!]
_has_keys_any: [String!]
_in: [jsonb!]
_is_null: Boolean
_lt: jsonb
_lte: jsonb
_neq: jsonb
_nin: [jsonb!]
}

Fields

_contained_in (jsonb)

is the column contained in the given json value

_contains (jsonb)

does the column contain the given json value at the top level

_eq (jsonb)

_gt (jsonb)

_gte (jsonb)

_has_key (String)

does the string exist as a top-level key in the column

_has_keys_all ([String!])

do all of these strings exist as top-level keys in the column

_has_keys_any ([String!])

do any of these strings exist as top-level keys in the column

_in ([jsonb!])

_is_null (Boolean)

_lt (jsonb)

_lte (jsonb)

_neq (jsonb)

_nin ([jsonb!])