
PostgreSQL 16.3 Documentation
5.10. Inheritance ............................................................................................... 96
5.11. Table Partitioning .................................................................................... 100
5.12. Foreign Data ........................................................................................... 114
5.13. Other Database Objects ............................................................................. 114
5.14. Dependency Tracking ............................................................................... 115
6. Data Manipulation ............................................................................................... 117
6.1. Inserting Data ........................................................................................... 117
6.2. Updating Data .......................................................................................... 118
6.3. Deleting Data ........................................................................................... 119
6.4. Returning Data from Modified Rows ............................................................ 119
7. Queries .............................................................................................................. 121
7.1. Overview ................................................................................................. 121
7.2. Table Expressions ...................................................................................... 121
7.3. Select Lists ............................................................................................... 138
7.4. Combining Queries (UNION, INTERSECT, EXCEPT) ..................................... 140
7.5. Sorting Rows (ORDER BY) ........................................................................ 141
7.6. LIMIT and OFFSET ................................................................................. 142
7.7. VALUES Lists ........................................................................................... 143
7.8. WITH Queries (Common Table Expressions) .................................................. 144
8. Data Types ......................................................................................................... 153
8.1. Numeric Types ......................................................................................... 154
8.2. Monetary Types ........................................................................................ 160
8.3. Character Types ........................................................................................ 161
8.4. Binary Data Types ..................................................................................... 163
8.5. Date/Time Types ....................................................................................... 165
8.6. Boolean Type ........................................................................................... 176
8.7. Enumerated Types ..................................................................................... 177
8.8. Geometric Types ....................................................................................... 179
8.9. Network Address Types ............................................................................. 181
8.10. Bit String Types ...................................................................................... 184
8.11. Text Search Types ................................................................................... 185
8.12. UUID Type ............................................................................................ 188
8.13. XML Type ............................................................................................. 188
8.14. JSON Types ........................................................................................... 190
8.15. Arrays .................................................................................................... 201
8.16. Composite Types ..................................................................................... 211
8.17. Range Types ........................................................................................... 218
8.18. Domain Types ......................................................................................... 225
8.19. Object Identifier Types ............................................................................. 225
8.20. pg_lsn Type ......................................................................................... 228
8.21. Pseudo-Types .......................................................................................... 228
9. Functions and Operators ....................................................................................... 231
9.1. Logical Operators ...................................................................................... 231
9.2. Comparison Functions and Operators ............................................................ 232
9.3. Mathematical Functions and Operators .......................................................... 236
9.4. String Functions and Operators .................................................................... 244
9.5. Binary String Functions and Operators .......................................................... 255
9.6. Bit String Functions and Operators ............................................................... 259
9.7. Pattern Matching ....................................................................................... 261
9.8. Data Type Formatting Functions .................................................................. 281
9.9. Date/Time Functions and Operators .............................................................. 289
9.10. Enum Support Functions ........................................................................... 306
9.11. Geometric Functions and Operators ............................................................ 307
9.12. Network Address Functions and Operators ................................................... 314
iv