Advanced Data Types in PostgreSQL
summary
Explains ENUMs, Arrays, Composite types, Range types, and how to implement custom types with concrete SQL and C functions. Demonstrates ENUM vs domain behavior (case sensitivity), arrays vs jsonb choices, a reservation exclude constraint using b3 gist, a domain for MD5 checks and a 150‑year life‑range check. Builds a boolean2 type that outputs 0/1 to satisfy PHP drivers, wires input/output/receive/send and indexing, and reports this fixes many compatibility issues while operating across 900–1000 PostgreSQL databases.
AI-written summary · about
chapters (10)
- 0:00Start
- 3:22Money
- 10:16Transform Aries into Strings
- 11:08Json B Types
- 16:57Jsonb Insert
- 19:55Domains
- 23:14Enum
- 29:55Range Types
- 31:48Indexes
- 39:09Create a New Type in Postgres
related talks
45mAdvanced Data Types in PostgreSQL
57mUnderstanding Advanced Datatypes in PostgreSQL
19mNO ARRAY OF SUNSHINE: an introduction to data types from a data quality perspective
50mRange Types in PostgreSQL 9.2 - Your Life Will Never Be the Same
29mPostgres Demystified
46mUse PostgreSQL to Step Up Your Game
57mUnderstanding Advanced Datatypes in PostgreSQL
25mJSON in PostgreSQL - evil data type or just needs to be tamed?