2 ms·
Late to the party but, I wish there was a way to have "named" constraints that you voukd share between tables. Because they would behave akin to mixins and tha
by moralestapia 4y ago
Late to the party but,
I wish there was a way to have "named" constraints that you voukd share between tables. Because they would behave akin to mixins and that would open up a world of possibilities.
(And if you're into that sort of thing, there's a lot of type theory concepts that could be applied on top of it that would make things much more practical and approachable)
Also, I'm eagerly waiting for Incremental View Maintenance to be merged into main postgres.
- ahachete 4y agoCheck DOMAINs. They are derived data types that take a base type and add, optionally, one or more CHECK constraints to them. They are not perfect, but probably something close to what you are looking for.
- moralestapia 4y agoThanks for this (!), I didn't know PG had support for data domains, wow.