4. Operators

In the sections below HTSQL operators are examined closely, grouped by usage categoties.

• If operator has several signatures, which differ in type of arguments, signatures come consecutive in the same paragraph.

• If operand is obligatory, it comes in square brackets ([ ]).

• If square brackets are part of operator syntax (in slice or index operators), they come double-quoted.

• If operand may happen more than once, it comes in curly brackets followed by asterisk ({ }*). For example:

  x | {y}*

• 4.1. Comparison Operators
  • 4.1.1. = (equals)
  • 4.1.2. != (not equals)
  • 4.1.3. == (null-safe equals)
  • 4.1.4. !== (null-safe not equals)
  • 4.1.5. > (greater)
  • 4.1.6. >= (greater or equals)
  • 4.1.7. < (less)
  • 4.1.8. <= (less or equals)
• 4.2. Boolean Operators
  • 4.2.1. | (disjunction, logical OR)
  • 4.2.2. & (conjunction, logical AND)
  • 4.2.3. ! (inversion, logical NOT)
  • 4.2.4. -> (implication)
• 4.3. String Operators
  • 4.3.1. [ ] (index)
  • 4.3.2. [:] (slice)
  • 4.3.3. + (concatenation)
  • 4.3.4. ~ (case-insensitive pattern check)
  • 4.3.5. !~ (case-insensitive inverse pattern check)
  • 4.3.6. ~~ (case-sensitive pattern check)
  • 4.3.7. !~~ (case-insensitive inverse pattern check)
• 4.4. Numeric Operators
  • 4.4.1. - (negation)
  • 4.4.2. + (addition)
  • 4.4.3. - (subtraction)
  • 4.4.4. * (multiplication)
  • 4.4.5. div
  • 4.4.6. mod
  • 4.4.7. ^ (power)
  • 4.4.8. bitwise_and
  • 4.4.9. bitwise_or
  • 4.4.10. bitwise_xor
  • 4.4.11. bitwise_lshift
  • 4.4.12. bitwise_rshift
• 4.5. Date And Time Operators
  • 4.5.1. - (negation)
  • 4.5.2. + (addition)
  • 4.5.3. - (subtraction)
  • 4.5.4. * (multiplication)
  • 4.5.5. div
• 4.6. Array Operators
  • 4.6.1. [ ] (index)
  • 4.6.2. [:] (slice)
  • 4.6.3. + (concatenation)
• 4.7. Aliasing and Assignment Operators
  • 4.7.1. as
  • 4.7.2. := (assignment)