Skip to main content

jsonb_comparison_exp

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

input jsonb_comparison_exp {
  _cast: jsonb_cast_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

`jsonb_comparison_exp._cast` ● `jsonb_cast_exp` input

`jsonb_comparison_exp._contained_in` ● `jsonb` scalar

is the column contained in the given json value

`jsonb_comparison_exp._contains` ● `jsonb` scalar

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

`jsonb_comparison_exp._eq` ● `jsonb` scalar

`jsonb_comparison_exp._gt` ● `jsonb` scalar

`jsonb_comparison_exp._gte` ● `jsonb` scalar

`jsonb_comparison_exp._has_key` ● `String` scalar

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

`jsonb_comparison_exp._has_keys_all` ● `[String!]` list scalar

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

`jsonb_comparison_exp._has_keys_any` ● `[String!]` list scalar

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

`jsonb_comparison_exp._in` ● `[jsonb!]` list scalar

`jsonb_comparison_exp._is_null` ● `Boolean` scalar

`jsonb_comparison_exp._lt` ● `jsonb` scalar

`jsonb_comparison_exp._lte` ● `jsonb` scalar

`jsonb_comparison_exp._neq` ● `jsonb` scalar

`jsonb_comparison_exp._nin` ● `[jsonb!]` list scalar

Fields