Time: 14:30 - 15:20
Room: Junior Ballroom G
Of course, you know everything you need to know about NULL, don't you ?
NULL and three-valued logic are often misunderstood and can induce poor written queries, wrong written queries (when the result is not as expected) and a lot of time lost trying to figure out what your missing colleague wanted to do with such a tricky and bad-twisted SQL code.
After defining NULL and UNKWON (and you'll see that it's not so simple), we'll go through different use cases where 3-valued logic is used, what pit you don't want to fall into and how you can improve query writing, now that you fully understand what's behind NULL in PostgreSQL.