String_comparison_exp

Boolean expression to compare columns of type "String". All fields are combined with logical 'AND'.
  • _gte
  • _ilike
    does the column match the given case-insensitive pattern
  • _iregex
    does the column match the given POSIX regular expression, case insensitive
  • _is_null
  • _like
    does the column match the given pattern
  • _lte
  • _neq
  • _nilike
    does the column NOT match the given case-insensitive pattern
  • _niregex
    does the column NOT match the given POSIX regular expression, case insensitive
  • _nlike
    does the column NOT match the given pattern
  • _nregex
    does the column NOT match the given POSIX regular expression, case sensitive
  • _nsimilar
    does the column NOT match the given SQL regular expression
  • _regex
    does the column match the given POSIX regular expression, case sensitive
  • _similar
    does the column match the given SQL regular expression