UNION but with excused columns

From: Mike Rowan <michael(dot)rowan3(at)gmail(dot)com>
To: pgsql-novice novice <pgsql-novice(at)postgresql(dot)org>
Subject: UNION but with excused columns
Date: 2018-05-28 01:36:47
Message-ID: CAL04MknwVhv9yHE4hdvNoWq_1+YZUKk4HeCxsgw1ztPzXEMS+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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?

Thanks for any ideas
Mike

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David Rowley 2018-05-28 01:42:06 Re: UNION but with excused columns
Previous Message Stephen Froehlich 2018-05-20 17:05:24 RE: pgbackrest archive-push exit code 25