Re: Conjunction junction
From: Laconic2 <laconic2_at_comcast.net>
Date: Mon, 1 Nov 2004 12:14:27 -0500
Message-ID: <JoWdnSRsGMlg8xvcRVn-3w_at_comcast.com>
Date: Mon, 1 Nov 2004 12:14:27 -0500
Message-ID: <JoWdnSRsGMlg8xvcRVn-3w_at_comcast.com>
"Alan" <alan_at_erols.com> wrote in message
news:2un1tqF2bo5daU1_at_uni-berlin.de...
> The worst part is, we don't even have an XOR in SQL.
Most of the time, you can get away with "not equal to" instead of XOR.
This is usually written "<>", but can be written as "=!" in some dialects,
IIRC.
So
select * from blocks
where
(color = 'RED') <> (shape = 'SQUARE')
It's ugly, but it's better than nothing. Received on Mon Nov 01 2004 - 18:14:27 CET