PGCon2009 - Final Release
PGCon 2009
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Greg Stark |
| Schedule | |
|---|---|
| Day | Talks - second day - 2009-05-22 |
| Room | DMS 1160 |
| Start time | 15:00 |
| Duration | 01:00 |
| Info | |
| 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?