**What is an Operator in PostgreSQL?**

An administrator is a saved word or a character utilized fundamentally in a PostgreSQL articulation's WHERE condition to perform operation(s, for example, examinations and number juggling tasks.

Administrators are utilized to determine conditions in a PostgreSQL articulation and to fill in as conjunctions for different conditions in an explanation.

- Math administrators
- Correlation administrators
- Coherent administrators
- Bitwise administrators

**PostgreSQL Arithmetic Operators**

Accept variable a holds 2 and variable b holds 3, at that point −

Operator | Description | Example |
---|---|---|

+ | Addition - Adds values on either side of the operator | a + b will give 5 |

- | Subtraction - Subtracts right hand operand from left hand operand | a - b will give -1 |

* | Multiplication - Multiplies values on either side of the operator | a * b will give 6 |

/ | Division - Divides left hand operand by right hand operand | b / a will give 1 |

% | Modulus - Divides left hand operand by right hand operand and returns remainder | b % a will give 1 |

^ | Exponentiation - This gives the exponent value of the right hand operand | a ^ b will give 8 |

|/ | square root | |/ 25.0 will give 5 |

||/ | Cube root | ||/ 27.0 will give 3 |

! | factorial | 5 ! will give 120 |

!! | factorial (prefix operator) | !! 5 will give 120 |

**PostgreSQL Comparison Operators**

Accept variable a holds 10 and variable b holds 20, at that point −

Operator | Description | Example |
---|---|---|

= | Checks if the values of two operands are equal or not, if yes then condition becomes true. | (a = b) is not true. |

!= | Checks if the values of two operands are equal or not, if values are not equal then condition becomes true. | (a != b) is true. |

<> | Checks if the values of two operands are equal or not, if values are not equal then condition becomes true. | (a <> b) is true. |

> | Checks if the value of left operand is greater than the value of right operand, if yes then condition becomes true. | (a > b) is not true. |

< | Checks if the value of left operand is less than the value of right operand, if yes then condition becomes true. | (a < b) is true. |

>= | Checks if the value of left operand is greater than or equal to the value of right operand, if yes then condition becomes true. | (a >= b) is not true. |

<= | Checks if the value of left operand is less than or equal to the value of right operand, if yes then condition becomes true. | (a <= b) is true. |

**PostgreSQL Logical Operators**

Here is a rundown of the relative multitude of sensible administrators accessible in PostgresSQL.

S. No. | Operator & Description |
---|---|

1 |
The AND operator allows the existence of multiple conditions in a PostgresSQL statement's WHERE clause. |

2 |
The NOT operator reverses the meaning of the logical operator with which it is used. Eg. NOT EXISTS, NOT BETWEEN, NOT IN etc. |

3 |
The OR operator is used to combine multiple conditions in a PostgresSQL statement's WHERE clause. |

**PostgreSQL Bit String Operators**

Bitwise administrator deals with bits and performs step by step activity. Reality table for and | is as per the following −

p | q | p & q | p | q |
---|---|---|---|

0 | 0 | 0 | 0 |

0 | 1 | 0 | 1 |

1 | 1 | 1 | 1 |

1 | 0 | 0 | 1 |

Accept if A = 60; and B = 13; presently in twofold arrangement they will be as per the following −

A = 0011 1100

B = 0000 1101

- -

A&B = 0000 1100

A|B = 0011 1101

~A = 1100 0011

Show Examples

The Bitwise administrators upheld by PostgreSQL are recorded in the accompanying table −

Operator | Description | Example |
---|---|---|

& | Binary AND Operator copies a bit to the result if it exists in both operands. | (A & B) will give 12 which is 0000 1100 |

| | Binary OR Operator copies a bit if it exists in either operand. | (A | B) will give 61 which is 0011 1101 |

~ | Binary Ones Complement Operator is unary and has the effect of 'flipping' bits. | (~A ) will give -61 which is 1100 0011 in 2's complement form due to a signed binary number. |

<< | Binary Left Shift Operator. The left operands value is moved left by the number of bits specified by the right operand. | A << 2 will give 240 which is 1111 0000 |

>> | Binary Right Shift Operator. The left operands value is moved right by the number of bits specified by the right operand. | A >> 2 will give 15 which is 0000 1111 |

# | bitwise XOR. | A # B will give 49 which is 0100 1001 |