Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id A364F475CC4
	for <pgsql-sql@postgresql.org>; Tue, 15 Oct 2002 08:53:18 -0400 (EDT)
Received: from out.juza.com (out.juza.com [212.108.195.66])
	by postgresql.org (Postfix) with ESMTP id 32F7D475B84
	for <pgsql-sql@postgresql.org>; Tue, 15 Oct 2002 08:53:17 -0400 (EDT)
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: set difference
X-MimeOLE: Produced By Microsoft Exchange V6.0.5762.3
content-class: urn:content-classes:message
Date: Tue, 15 Oct 2002 14:52:23 +0200
Message-ID: <D6CD29CE4DF67F47A11FB6CF5EBE15D10ECC55@gedeon.finit.local>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: set difference
Thread-Index: AcJ0ScfHcOM8OnaBScmKqhEmKCAliw==
From: =?iso-8859-1?Q?Domoszlai_L=E1szl=F3?= <dlacko@finit.hu>
To: "SQL PostgreSQL (E-mail)" <pgsql-sql@postgresql.org>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/160
X-Sequence-Number: 9877

Hello,

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

select id from a=20
except
select id from b
union=20
select id from b
except
select id from a

Is there any better solution for this problem?

Thanks
Laca