=?iso-8859-1?Q?Domoszlai_L=E1szl=F3?= <[EMAIL PROTECTED]> writes:
> So, do you think a DIFFERENCE or EXCEPT SYMMETRIC clause will be reasonable
> feauture for postgresql?
I doubt it; haven't heard a request for it before, and AFAICS there's no
such thing in the SQL spec...
Tom Lane wrote:
> > 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?
=?iso-8859-1?Q?Domoszlai_L=E1szl=F3?= <[EMAIL PROTECTED]> writes:
> 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
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
---(end of
