Examples 615–629 · Part VI: PostgreSQL's Distinctive Types
| # | Example | Level |
|---|---|---|
| 615 | UUID as a primary key | Beginner |
| 616 | UUID versus bigint keys | Intermediate |
| 617 | Time-ordered UUIDs | Intermediate |
| 618 | ENUM types | Beginner |
| 619 | Altering an enum | Intermediate |
| 620 | Enum versus lookup table versus check | Intermediate |
| 621 | Domains | Intermediate |
| 622 | Composite types | Intermediate |
| 623 | Range types | Intermediate |
| 624 | Multiranges | Intermediate |
| 625 | Exclusion constraints on ranges | Intermediate |
| 626 | Network address types | Intermediate |
| 627 | Bit strings and binary data | Intermediate |
| 628 | Index support across the distinctive types | Advanced |
| 629 | Choosing among PostgreSQL's distinctive types | Advanced |
The solutions and explanations are in the book.