Combine queries using the union, intersection, or difference operators (from http://www.postgresql.org/docs/9.4/static/queries-union.html) - Cacher Snippet

3/3/2016 - 11:46 AM

Combine queries using the union, intersection, or difference operators (from http://www.postgresql.org/docs/9.4/static/queries-union.html)

Combine queries using the union, intersection, or difference operators (from http://www.postgresql.org/docs/9.4/static/queries-union.html)

combine_queries.sql

(select ... from ...) foo union (select ... from ...) bar;
(select ... from ...) foo intersect (select ... from ...) bar;
(select ... from ...) foo except (select ... from ...) bar;