PGCon2009 - Final Release

PGCon 2009
The PostgreSQL Conference

Greg Stark
Day Talks - second day - 2009-05-22
Room DMS 1160
Start time 15:00
Duration 01:00
ID 181
Event type Lecture
Track Version 8.4
Language used for presentation English

Introduction to Recursive Queries

Recursion: see recursion

Introduction to new 8.4 feature "WITH RECURSIVE" with examples of querying recursive database data structures such as trees or graphs.

Recursive Queries is just one of several long-awaited SQL features planned for PostgreSQL 8.4. But what is a recursive query anyways? What could it possibly mean to have a query refer to its own result set? What could such a thing be useful for?