Shulou(Shulou.com)06/01 Report--

Postgresql has a wealth of internal operators, which can be divided into four main categories: arithmetic operators, comparison operators, logical operators, and bit operation operators. As follows:

①: arithmetic operator:

Used for all kinds of numerical operations, including addition (+) minus (-) multiplication (*) division (/) to find the remainder (%)

Example:

Testdb=# create table emp (num int)

Testdb=# insert into emp values (60)

Testdb=# select num,num+10,num-10,num+10-5 numb 10.5 from emp;-add and subtract the field

Num |? column? |? column?

-+-

60 | 70 | 50 | 65 | 70.5

(1 row)

Testdb=# select num,num*2,num/3,num%2 from emp;-perform multiplication and division on fields

Num |? column? |? column? |? column?

-+-

60 | 120 | 20 | 0

(1 row)

②: comparison operator

Used for comparison operations, including greater than (>) less than (=) less than or equal to (

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.