Very weird how the `NOT IN` logic is implemented. I assumed it would've just been the negation (`~`) of the `IN` logic's operator since that would be much more efficient. Also, first time hearing about ANTI JOINs!
Excellent article (again) about one of my favourite topics: "There are many troubles caused by nothing". 'Nothing' meaning missing data of course. A small remark: "missing vlaues" sounds a bit Lithuanian to me...
Very weird how the `NOT IN` logic is implemented. I assumed it would've just been the negation (`~`) of the `IN` logic's operator since that would be much more efficient. Also, first time hearing about ANTI JOINs!
Very nice!
Excellent article (again) about one of my favourite topics: "There are many troubles caused by nothing". 'Nothing' meaning missing data of course. A small remark: "missing vlaues" sounds a bit Lithuanian to me...
This has happened to me too 🤷♂️😅
I usually use coalesce + trim to replace the null value with an empty value and avoid empty strings at the same time.