News for hackers. Stuff that matters.

A comment on For Want of a JOIN. Parent comment

Re:For Want of a JOIN by int_19h on Friday December 23, 2022 @06:29PM (#34111900)
This is an arbitrary distinction in the first place. You can absolutely have a relational database that only allows 0 and 1 as valid values and requires you to build integers up yourself using relational techniques. The relational model itself doesn't care what "values" are.

In practice, simple value tuples make things much more convenient, and the edge cases are minimal. You don't have to allow full-fledged composition like nested tables etc.

[ Parent | on HN ]
Re:For Want of a JOIN by goto11 on Monday December 26, 2022 @11:38AM (#34139204)
> The relational model itself doesn't care what "values" are.

Maybe I misunderstand what you are arguing, but the relational model is defined in terms of values and domains (data types), but of course the domains chosen for a particular database schema depends on the business requirements.

[ Parent | on HN ]