Re: a wierd query - Mailing list pgsql-sql

sad wrote:
> select distinct a as F from table
> union
> select distinct b as F from table;
>

Note that UNION only returns the unique values of the union
You can get repeated values by using UNION ALL.


-- 
Edmund Bacon <ebacon@onesystem.com>