ORA-XQ-114-C: Please point out none of our expectations about order hold

SECTION 3.5.2: general comparisons

From the examples, second bullet illustrates that = is not 
transitive.  I think it would also be useful to point out that
= and != are not logical negations of each other.  For 
example, (1, 2) = (1, 3) is true (because 1=1), and 
(1, 2) != (1, 3) is also true (because 2 != 3).  In fact, 
almost all of our accustomed rules about these comparison
operators do not hold.  Thus
(1, 2) > (1, 3) because 2 > 1; (1, 2) < (1, 3) because 1 < 3.
In fact, all six relationships are true between (1, 2) and (1, 3).


- Steve B.

Received on Monday, 16 February 2004 15:02:06 UTC