PostgreSQL: Up and Running, 3rd Edition

Index

Symbols

• #> pointer symbol, Querying JSON
• #>> operator, Querying JSON
• $$ (dollar quoting), Dollar Quoting-DO
• & (and operator), TSQueries
• && (and operator), TSQueries
• && (overlap operator), Array Containment Checks, Overlap operator, Exclusion Constraints
• () (parentheses), Building Custom Data Types
• + (addition operator), Datetime Operators and Functions
• - (subtraction operator), Datetime Operators and Functions, Editing JSONB data, Editing JSONB data
• -> operator, Querying JSON
• ->> operator, Querying JSON
• : (colon), Shortcuts
• <-> (distance operator), Features Introduced in PostgreSQL 9.6
• <@ (contained in operator), Array Containment Checks, Contains and contained in operators, Binary JSON: jsonb
• = (equality operator), Array Containment Checks, Binary JSON: jsonb
• ? (key exists operator), Binary JSON: jsonb
• ?& (all of array of keys exists operator), Binary JSON: jsonb
• ?| (any of array of keys exists operator), Binary JSON: jsonb
• @ sign, selecting attributes of elements, Querying XML Data
• @> (contains operator), Array Containment Checks, Contains and contained in operators, Binary JSON: jsonb
• @@ operator, Using Full Text Search
• \ (backslash), Regular Expressions and Pattern Matching
• \! command, Executing Shell Commands
• | (or operator), TSQueries
• || (concatenation operator), String Functions, Array Slicing and Splicing, Editing JSONB data, TSVectors
• || (or operator), TSQueries
• ~ (similar to operator), Regular Expressions and Pattern Matching
• ~~ operator, Operator Classes

A

• addition operator (+), Datetime Operators ...