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 ...
Get PostgreSQL: Up and Running, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.