PGCon2015 - final
PGCon 2015
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Markus Winand |
| Schedule | |
|---|---|
| Day | Talks - Day 3 - Thursday - 2015-06-18 |
| Room | DMS 1120 |
| Start time | 14:00 |
| Duration | 00:45 |
| Info | |
| 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.