PGCon2015 - final

PGCon 2015
The PostgreSQL Conference

Markus Winand
Day Talks - Day 3 - Thursday - 2015-06-18
Room DMS 1120
Start time 14:00
Duration 00:45
ID 790
Event type Lecture
Track Applications
Language used for presentation English

Modern SQL in PostgreSQL

A lot has changed since SQL:92

SQL has gone out of fashion lately --- partly due to the NoSQL movement, but mostly because SQL is often still used like 20 years ago. As a matter of fact, the SQL standard continued to evolve during the past decades resulting in the current release of 2011.

In this session, we will go through the most important additions since the widely known SQL-92, explain how they work and how PostgreSQL extends them. We will cover common table expressions and window functions in detail and have a very short look at the temporal features of SQL:2011 and the related features of PostgreSQL.