News for hackers. Stuff that matters.
Re:Modern SQL in PostgreSQL by rosser on Sunday February 08, 2015 @08:42PM (#9019357)
Other than The Fine Manual, linked by a sibling comment, not really. Everything I've learned, I've just picked up along the way.

EDIT: When I wanted to learn about CTEs, for example, I conveniently had a large, ugly materialized view that needed refactoring, and they happened to fit the need perfectly. The previous version was, in places, five or six layers of subqueries deep, many of them repeated several times as they were reused. It hurt to read. Rewriting it to use CTEs made it about eight times faster, and the SQL script was a third the size of the original.

There are no comments on this comment yet.