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?