set difference - Mailing list pgsql-sql

From Domoszlai László
Subject set difference
Date
Msg-id D6CD29CE4DF67F47A11FB6CF5EBE15D10ECC55@gedeon.finit.local
Whole thread Raw
Responses Re: set difference
List pgsql-sql
Hello,

I would like to make symmetrical(set) difference in a query.
But the simpliest way I could find is

select id from a
except
select id from b
union
select id from b
except
select id from a

Is there any better solution for this problem?

Thanks
Laca





pgsql-sql by date:

Previous
From: Larry Rosenman
Date:
Subject: Messy Casts, Is there a better way?
Next
From: Tom Lane
Date:
Subject: Re: Stored procedure returning row or resultset