Operator Precedence Demo : Operator Precedence « Select Query « PostgreSQL

1.	Aggregate Functions
2.	Analytical Functions
3.	Array
4.	Constraints
5.	Cursor
6.	Data Type
7.	Database
8.	Date Timezone
9.	Index
10.	Inheritance
11.	Insert Delete Update
12.	Math Functions
13.	Postgre SQL
14.	Select Query
15.	Sequence
16.	Store Procedure Function
17.	String Functions
18.	Subquery
19.	Table
20.	Table Joins
21.	Transaction
22.	User Previliege
23.	View

PostgreSQL » Select Query » Operator Precedence

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

Related examples in the same category

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.