PG Phriday: Everything in Common
http://bonesmoses.org/2017/01/20/pg-phriday-everything-in-common/ [bonesmoses.org]
2017-01-22 03:46
CTEs changed these things for the better and in the eyes of many, finally brought Postgres to parity with Oracle and its long-established recursive query support. So let’s explore what CTEs really deliver, and how they can improve our Postgres experience—caveats and all.
Fun with Common Table Expressions.