PostgreSQL/Select Query/Operator Precedence

Operator Precedence Demo

   <source lang="sql">

postgres=# postgres=# -- Operator Precedence postgres=# postgres=# SELECT 60 + 12 * 5 AS "sixty plus twelve times five",12 + 60 * 5 AS "twelve plus sixty times five";

sixty plus twelve times five | twelve plus sixty times five

---

+------------------------------

                         120 |                          312

(1 row) postgres=# postgres=#

      </source>