Vik Fearing

"NULL" is a single token in SQL with at least six distinct meanings, and the standard is conspicuously quiet about which one you're getting at any given site. A NULL produced by an outer join doesn't mean the same thing as a NULL in an unpopulated column, which doesn't mean the same thing as the NULL SUM returns over an empty set, which doesn't mean the same thing as the NULL a ROLLUP...

Why do we have an SQL standard if no implementations follow it? PostgreSQL tries to follow it but fails in several different ways. Why do we even care? How can the Standard help PostgreSQL, and how can PostgreSQL help the Standard? Lots of questions, some without answers.

This talk will present SQL/PGQ, a new feature of the upcoming SQL:2023 standard. Sometimes the data we need to deal with and the way we need to query it is too much for the relational model.

PostgreSQL is extremely compliant with the SQL Standard, but there are some features that it lacks, and some that it gets wrong. This talk will look at the differences with the Standard and some really nice features that it would be good to have in PostgreSQL.

PostgreSQL is extremely compliant with the SQL Standard, but there are some features that it lacks, and some that it gets wrong. This talk will look at the differences with the Standard and some really nice features that it would be good to have in PostgreSQL.

PostgreSQL is extremely compliant with the SQL Standard, but there are some features that it lacks, and some that it gets wrong. This talk will look at the differences with the Standard and some really nice features that it would be good to have in PostgreSQL.

SQL:2011 introduced the concept of a Period. These can be used for many things but the most well-known application is system versioned tables where all changes to a table are recorded and can be summoned via SQL.