# Operator Order of Precedence

The below table shows order of operations for all operators, from highest to lowest precedence.

Operator | Associativity | Description |
---|---|---|

`()` | Parentheses | |

`.` | Left | Member Access |

`[]` | Left | Array Index |

`-` | Right | Negation |

`COLLATE` | Left | Collation |

`*` , `/` , `%` | Left | Multiplication, Division, Modulo |

`+` , `-` | Left | Addition, Subtraction |

any other expression | Left | any other expression |

`IN` | Set Membership | |

`LIKE` , `ILIKE` | Pattern Matching | |

`BETWEEN` | Range Comparison | |

`==` , `!=` , `=` , `>` , `<` , `>=` , `<=` | Comparison | |

`IS` | Type Comparison | |

`NOT` | Right | Logical NOT |

`AND` | Left | Logical AND |

`OR` | Left | Logical OR |