Re: UNION discards indentical rows in postgres 7.3.3 - Mailing list pgsql-bugs

> Wrong ! The query should return 4 rows. In other words i don't know
> why postgres performs the following query:

I think the syntax you're looking for is UNION ALL.

select a,b from t1 union all (select distinct a,b from t2);