Re: [BUGS] UNION discards indentical rows in postgres 7.3.3

[Rod Taylor]

> 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);

signature.asc
Description: This is a digitally signed message part