Here's another explanation from the Postgres docs with additional examples: http://www.postgresql.org/docs/9.3/static/queries-table-expr...