Mark Kelly wrote:
> If I have two queries:
>
> SELECT pub_id as id, email FROM publication WHERE email_accepted = TRUE;
>
> and
>
> SELECT contact_id as id, email FROM person WHERE email_accepted = TRUE;
>
> is there any way I could combine these into a single query? I'd like to be
> able to create a view of all email-able entities in the system.
Sean Davis wrote:
> Take a look at sql UNION--this is not postgresql specific.
Thomas Kellerer wrote:
> More precisely: UNION ALL to avoid the redundant step that tries to eliminate
> duplicates
One may eliminate the redundant test of a truth value against a truth value.
SELECT pub_id as id, email FROM publication WHERE email_accepted
UNION ALL
SELECT contact_id as id, email FROM person WHERE email_accepted ;
One trusts that the result columns in the two tables have compatible types.
I am curious how you interpret the "id" result in that query.
--
Lew
Honi soit qui mal y pense.