References
SQL Reference
SQL Expressions

Reference: SQL Expressions

CedarDB supports many expressions that manipulate data:

  • Abs (@)
  • Access (->)
  • And (&&)
  • At time zone
  • Between, between symmetric
  • Bit and (&)
  • Bit or (|)
  • Bit xor (#)
  • Case-insensitive like (ilike, ~~*), negated (not ilike, !~~*)
  • Case-insensitive regular expression (~*), negated (!~*)
  • Casting (::)
  • Coalesce
  • Concat (||)
  • Conditionals (case when)
  • Contains (@>)
  • Cube root (||/)
  • Div (/)
  • Equal (=, ==), not equal (<>, !=)
  • Exists subquery
  • Factorial (!, !!)
  • Greater (>)
  • Greater or equal (>=)
  • Greatest / Least
  • In
  • Is contained (<@)
  • Is distinct from
  • Is null
  • Less (<)
  • Less or equal (<=)
  • Like (like, ~~), not like (not like, !~~)
  • Minus (-)
  • Mod (%)
  • Mul (*)
  • Nullif
  • Or
  • Plus (+)
  • Pow (^)
  • Regular expressions matching (~), negated (!~)
  • Scalar subquery
  • Shift left bitwise (<<)
  • Shift right bitwise (>>)
  • Similar to
  • Square root (|/)
  • Try
  • Unique subquery
QueriesFunctions