Practical SQL

INDEX

Symbols

+ (addition operator), 56, 57

& (ampersand operator), 232, 236

* (asterisk)

as multiplication operator, 56, 57

as wildcard in SELECT, 12

\ (backslash), 42–43, 215

escaping characters with, 219

, (comma), 40

||/ (cube root operator), 56, 58

{} (curly brackets), 215

denoting an array, 68

<-> (distance operator), 232, 236

@@ (double at sign match operator), 232

:: (double-colon CAST operator), 36

$$ (double-dollar quoting), 280

|| (double-pipe concatenation operator), 143, 225

" (double quote), 41, 94

= (equals comparison operator), 18

! (exclamation point)

as factorial operator, 56, 59

as negation, 228, 232, 236

^ (exponentiation operator), 56, 58

/ (forward slash)

as division operator, 56, 57

in macOS file paths, 42

> (greater than ...