Re: a wierd query - Mailing list pgsql-sql

On Thursday 13 May 2004 19:27, you wrote:
> 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.

read the original problem
look at the DISTINCT clause in my query
and think again