Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Type Constraints in 65 lines of SQL. Parent comment
""Using composite types is mildly annoying since you must wrap the composite column in parenthesis to access the field"""
^ yeah that is frustrating
--
if you create domains over jsonb frequently, check out pg_jsonschema[1] as a way to express the constraints more concisely
[1] https://github.com/supabase/pg_jsonschema
There are no comments on this comment yet.
""Using composite types is mildly annoying since you must wrap the composite column in parenthesis to access the field"""
^ yeah that is frustrating
--
if you create domains over jsonb frequently, check out pg_jsonschema[1] as a way to express the constraints more concisely
[1] https://github.com/supabase/pg_jsonschema