Re: stupid SQL question, how reach different rows of two almost same tables

On 10/4/05, Jaromír Kamler <kamler(at)centrum(dot)cz> wrote:
> I am sorry, I know that this is an SQL problem ... . I need reach different
> rows in 2 almost same tables. I need use it in PL/pgSQL. Thanks for your
> advidce.
>
>

this works?...

create temp table t1 as
select * from (select * from foo1 intersect select * from foo2) as tmp_foo;

select * from (select * from foo1 except select * from t1) as tmp_foo1
union
select * from (select * from foo2 except select * from t1) as tmp_foo2;

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)