Hacker News new | past | comments | ask | show | jobs | submit login

In any normal/half-way good designed application, no row should be duplicated within a table, thus a comparison with EXCEPT is a valid solution. And it's often used in practice.



> In any normal/half-way good designed application, no row should be duplicated within a table...

Sure, but there are plenty of poorly designed databases out there!




Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: