Re: Combining queries

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.