Craig Kerstiens craigkerstiens.com

The best Postgres feature you're not using  ↦

Craig Kerstiens on why common table expressions (CTEs) are so cool:

For some reason most people throw out principles we follow in other languages such as commenting and composability just for SQL. … [CTEs] actually makes SQL both readable and composable, and even for my own queries capable of coming back to them months later and understanding them, where previously they would not be.

Click through for examples of these in use.


Discussion

Sign in or Join to comment or subscribe

Player art
  0:00 / 0:00