Re: Impossible for a number multiplied by zero to equal zero

On Oct 14, 8:23 pm, Don Del Grande <del_grande_n...@xxxxxxxxxxxxx>
wrote:
Mensanator wrote:
Actually, you have this bass-ackwards. A NULL *will* cancel a
numerical
value. The rule is any mathematical expression containing a NULL
evaluates to NULL. Thus, 1+NULL=NULL or 3*NULL=NULL. The same applies
to 0, which is just another number: 0+NULL=NULL and 0*NULL=NULL.

You would think that 0 * NULL = 0, since NULL usually means "it could
be anything".

Could be, but is, in fact, unknown. Where I use it, this behaviour
is EXACTLY the correct interpretation. If I need to plot the
water table contours, I have to subtract the well DepthToWater
measurements from the surveyed TopOfCasing. If the water depth
is unknown, I WANT the calculated water table elevation to be
unknown, I do NOT want it to treat the unknown DTW as 0 because
that would result in a false calculation which is worse than
a missing calculation.

 (I do know in ORACLE that (NULL and FALSE) = FALSE, and
(NULL or TRUE) = TRUE.)

Well, I don't use Oracle and don't think I've ever tried that
in Access. Offhand, it sounds inconsisent.


-- Don\

.

Relevant Pages

  • Re: Is this guy familiar with Sean Pitman?
    ... mathematical calculation shows that some routine process is impossible, ... You forget, John, that common descent isn't a "mechanism". ... What mechanism for ID are you proposing, Sean? ... How can I go about testing the, uh, hypothesis that "an unknown thing ...
    (talk.origins)
  • Re: Impossible for a number multiplied by zero to equal zero
    ... The rule is any mathematical expression containing a NULL ... water table contours, I have to subtract the well DepthToWater ... unknown, I do NOT want it to treat the unknown DTW as 0 because ... that would result in a false calculation which is worse than ...
    (sci.math)
  • Re: Computation of AIC and AIC with weights
    ... In accordance with Venables and Ripley, SAS documentation and other ... Why the slight difference between my calculation in R and R's AIC? ... -joe yarmus ... represented by the constant + 2) and the unknown ...
    (sci.stat.math)
  • RE: how do I test for Integer?
    ... > I wish to test if the results of a calculation is an integer. ... An unknown ... > function perhaps in the stats package? ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Impossible for a number multiplied by zero to equal zero
    ... The rule is any mathematical expression containing a NULL ... Could be, but is, in fact, unknown. ... water table contours, I have to subtract the well DepthToWater ... that would result in a false calculation which is worse than ...
    (sci.math)