Re: UNION but with excused columns

On 28 May 2018 at 13:36, Mike Rowan <michael.rowan3@gmail.com> wrote:
> I would like to use UNION to amalgamate two result sets, but I need to
> excuse some columns (the same columns in each set) from the matching
> requirement.  The unmatched columns are the same data type, but not the same
> data.
>
> Is this possible, and if so, any clues?

Yes, just use a sub-query: e.g: SELECT a,b,c FROM (SELECT a,b,c,d FROM
t1 UNION SELECT a,b,c,d FROM t2) t;

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services