Agreed. The Postgres "with" statement is also a great way to make large queries readable: http://www.postgresql.org/docs/9.2/static/queries-with.html http://ww

Agreed. The Postgres "with" statement is also a great way to make large queries readable: http://www.postgresql.org/docs/9.2/static/queries-with.html http://www.postgresql.org/docs/9.2/static/queries-with.html I first saw this demonstrated in Peter van Hardenberg's excellent Waza 2013 presentation, "Postgres: The Bits You Haven't Found": http://vimeo.com/61044807 http://vimeo.com/61044807