3 ms·
I'm not sure why you need to restrict constraints between tables to be based on foreign keys. I guess maybe that is a limitation inherent to SQL? We also allo
by trurl 8y ago
I'm not sure why you need to restrict constraints between tables to be based on foreign keys. I guess maybe that is a limitation inherent to SQL?
We also allow constraints over aggregations. Though our syntax does require giving the result of the aggregation a temporary "table" name so that it can be used as part of the constraint.
- gsvigruha 8y agoI dont need to, thats a design choice i made for the moment for various reasons, one being to stay close to SQL concepts. It seems like your DB is basically a Datalog version of what im trying to do in SQL.