3 ms·
Enums are not relations but data types as indicated in the first paragraph here: https://www.postgresql.org/docs/current/static/datatype-enum.html https://www.p
by krychu 8y ago
Enums are not relations but data types as indicated in the first paragraph here: https://www.postgresql.org/docs/current/static/datatype-enum.html https://www.postgresql.org/docs/current/static/datatype-enum..., and by the related command ‘CREATE TYPE ...’.
Relations are commonly used when referring to tables and views.
What do you gain by calling types relations while introducing confusion and diminishing practicality of the relation concept?
- mamcx 8y agoThat is true. In postgresql. Not int the relational model.
- dragonwriter 8y agoFinite data types are, or are isomorphic to, (constant) relations, they aren't relvars like tables/views (relations include both constant relations and relvars.) > What do you gain by calling types relations The fact that everything true of other relations is true of finite types.