Schedule - FOSDEM PGDay 2018

Standard SQL features where PostgreSQL beats its competitors

Date: 2018-02-02
Time: 10:20–11:10
Room: Hotel
Level: Intermediate

The SQL standard has more than 4300 pages and hundreds of optional features. The number of features offered by different products varies vastly. PostgreSQL implements a relativley large number of them.

In this session I present some standard SQL features that work in PostgreSQL, but not in other popular open-source databases. But when it comes to standard conformance, PostgreSQL doesn’t even need to fear the comparison to its commercial competitors: PostgreSQL also supports a few useful standard SQL features that don’t work in any of the three most popular commercial SQL databases.


The following slides have been made available for this session:


Markus Winand