PostgreSQL/Select Query/Operator Precedence

Материал из SQL эксперт
Перейти к: навигация, поиск

Operator Precedence Demo

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=#