Citus Data Blog company blog
Recursive Common Table Expressions in Postgres
Common Table Expressions in PostgreSQL are a powerful SQL construct. You can think of CTEs as a view that is materialized only while the query is running. Recursive CTEs allow themselves to be called until some condition is met. This post from the Citus Data team explores how recursive CTEs work in Postgres.
- Points
- 202
- HN comments
- 97
- Submissions
- 1
- Cited by
- 0 commenters
Databases & DataSoftware Engineering2018
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| May 22, 2018 | Recursive Common Table Expressions in Postgres by jesperht | 202 | 97 |
