Skip to main content

String_comparison_exp

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

input String_comparison_exp {
  _eq: String
  _gt: String
  _gte: String
  _ilike: String
  _in: [String!]
  _iregex: String
  _is_null: Boolean
  _like: String
  _lt: String
  _lte: String
  _neq: String
  _nilike: String
  _nin: [String!]
  _niregex: String
  _nlike: String
  _nregex: String
  _nsimilar: String
  _regex: String
  _similar: String
}

Fields

`String_comparison_exp._eq` ● `String` scalar

`String_comparison_exp._gt` ● `String` scalar

`String_comparison_exp._gte` ● `String` scalar

`String_comparison_exp._ilike` ● `String` scalar

does the column match the given case-insensitive pattern

`String_comparison_exp._in` ● `[String!]` list scalar

`String_comparison_exp._iregex` ● `String` scalar

does the column match the given POSIX regular expression, case insensitive

`String_comparison_exp._is_null` ● `Boolean` scalar

`String_comparison_exp._like` ● `String` scalar

does the column match the given pattern

`String_comparison_exp._lt` ● `String` scalar

`String_comparison_exp._lte` ● `String` scalar

`String_comparison_exp._neq` ● `String` scalar

`String_comparison_exp._nilike` ● `String` scalar

does the column NOT match the given case-insensitive pattern

`String_comparison_exp._nin` ● `[String!]` list scalar

`String_comparison_exp._niregex` ● `String` scalar

does the column NOT match the given POSIX regular expression, case insensitive

`String_comparison_exp._nlike` ● `String` scalar

does the column NOT match the given pattern

`String_comparison_exp._nregex` ● `String` scalar

does the column NOT match the given POSIX regular expression, case sensitive

`String_comparison_exp._nsimilar` ● `String` scalar

does the column NOT match the given SQL regular expression

`String_comparison_exp._regex` ● `String` scalar

does the column match the given POSIX regular expression, case sensitive

`String_comparison_exp._similar` ● `String` scalar

does the column match the given SQL regular expression

Fields