This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2019

Meet NULL the UNKNOWN

Date: 2019-10-16
Time: 10:50–11:40
Room: Manzoni
Level: Intermediate

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.

Slides

The following slides have been made available for this session:

Speaker

Lætitia AVROT