Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

PostgreSQL > Operators > Flashcards

Operators Flashcards

1
Q

Comparison Operator <

A

less than

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Comparison Operator >

A

greater than

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Comparison Operator <=

A

less than or equal to

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Comparison Operator >=

A

greater than or equal to

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Comparison Operator =

A

equal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Comparison Operator <>

A

not equal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Comparison Operator !=

A

not equal ( != operator is converted to <> in the parser stage)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Name All Comparison Operators

A

< less than, > greater than, = greater than or equal to, = equal, <> or != not equal, BETWEEN greater than or equal to and lower than or equal to

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Mathematical Operator +

A

addition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Mathematical Operator -

A

subtraction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Mathematical Operator *

A

multiplication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Mathematical Operator /

A

division (integer division truncates results)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Mathematical Operator %

A

modulo (remainder)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Mathematical Operator ^

A

exponentiation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Mathematical Operator |/

A

square root

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Mathematical Operator ||/

A

cube root

17
Q

Mathematical Operator !

A

factorial

18
Q

Mathematical Operator !!

A

factorial (prefix operator)

19
Q

Mathematical Operator @

A

absolute value

20
Q

Mathematical Operator &

A

bitwise AND

21
Q

Mathematical Operator |

A

bitwise OR

22
Q

Mathematical Operator #

A

bitwise XOR

23
Q

Mathematical Operator ~

A

bitwise NOT

24
Q

Mathematical Operator «

A

bitwise shift left

25
Q

Mathematical Operator&raquo_space;

A

bitwise shift right

26
Q

String Operator ||

A

Concatenation

27
Q

Miscellaneous Operator ::

A

Cast. Historical, use CAST function instead

28
Q

BETWEEN Construct

A

greater than or equal to and less than or equal to

PostgreSQL (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions