Re: union of types in a different category - Mailing list pgsql-general

>
> Interestingly - & i'm curious as to why"
>
> SELECT '1' UNION SELECT 2;
>  ?column?
> ----------
>         1
>         2
> (2 rows)
>
> SELECT '1' UNION SELECT 1;
>  ?column?
> ----------
>         1
> (1 row)
>
>
> I didn't think UNION did an explicit "distinct" - if that is what is happening?
>

UNION removes duplicates. UNION ALL does not.

James