ENUM, DOMAIN, and composite types

CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');
CREATE TABLE person (id BIGINT PRIMARY KEY, mood mood DEFAULT 'ok');
INSERT INTO person VALUES (1, 'happy');   -- invalid label errors
SELECT * FROM person WHERE mood = 'happy' ORDER BY mood;
SELECT enum_range(NULL::mood);
DROP TYPE IF EXISTS mood;

CREATE DOMAIN us_zip AS TEXT CHECK (VALUE ~ '^[0-9]{5}$');
CREATE DOMAIN qty AS INT CONSTRAINT positive CHECK (VALUE > 0) CONSTRAINT small CHECK
  (VALUE < 1000000);
CREATE TABLE o (id BIGINT PRIMARY KEY, zip us_zip, q qty NOT NULL DEFAULT 1);

CREATE TYPE address_type AS (street TEXT, city TEXT, zip TEXT);
CREATE TABLE c (id BIGINT PRIMARY KEY, addr address_type);
INSERT INTO c VALUES (1, ROW('5 Main', 'Springfield', '12345'));
SELECT (addr).street, (addr).city FROM c;
SELECT json_populate_record(NULL::c, '{"id":2}') FROM c LIMIT 1;