4 ms·
Both EdgeQL and SQL disregard the RM proscription about duplicate tuples for practical reasons: 1. Elimination of duplicates from every projection is prohibiti
by RedCrowbar 6y ago
Both EdgeQL and SQL disregard the RM proscription about duplicate tuples for practical reasons:
1. Elimination of duplicates from every projection is prohibitively expensive.
2. Sometimes you actually _want_ duplicates to show up without injecting a synthetic key into every projection.
3. There's DISTINCT.