Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: The naive test for equality

Re: The naive test for equality

From: Paul <paul_at_test.com>
Date: Tue, 02 Aug 2005 17:03:14 +0100
Message-ID: <42ef9948$0$24030$ed2619ec@ptn-nntp-reader01.plus.net>


Marshall Spight wrote:
> Sure. Specifically, it's an equivalence relation. Let's distinguish
> between the equality relation specifically and equivalence relations
> in general. Equality is a much simpler thing.

Is it, though? We think about 1/2 = 2/4 fine even though they have different representations. Maybe you mean "identity", often shown using a variant of the equals sign with three lines instead of two?

It's rare that we use the "equals" symbol to compare two things with identical representation: 1=1, we'd use the "identity" symbol instead.

It's all about levels of abstraction: equality at the physical layer (representation) may differ from equality at the logical layer (value).

So for the underlying relational engine to compare two values for equality, it can't in general stay in the physical layer; it has just jump up into the logical layer, do the comparison, and then jump back down to the physical layer again.

Paul. Received on Tue Aug 02 2005 - 11:03:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US