Re: NULLs: theoretical problems?

From: Jan Hidders <>
Date: Thu, 23 Aug 2007 21:00:11 -0000
Message-ID: <>

On 23 aug, 00:13, "V.J. Kumar" <> wrote:
> Jan Hidders <> wrote
> > On 22 aug, 17:37, "V.J. Kumar" <> wrote:
> >> In your language, the expression 'def y:x AND y' where 'y' is
> >> 'undefined' evaluates to 'false'. In SQL, the expression 'x AND y'
> >> where 'y'is 'unknown' evaluates to 'unknown'. The effect of having a
> >> predicate that evaluates to 'unknown' is the same as having a
> >> predicate that evaluates to 'false': no rows will be selected.
> >> That's what I meant by "substituting 'false' for unknown".
> > That's not exactly the same because there are formulas f(x) that
> > evaluate to 'true' if x is 'unknown'.
> I am not sure I understand what you mean by "That's not exactly the
> same...", but I'll take a stab at it.

I mean that if you take a select-from-where query with a formula f in in the where clause containing the DEF construct then replacing f with f' where all the DEF constructs are removed (i.e. we replace "DEF x : g" with "g" until there are no more such expressions) sometimes changes the meaning of the query.

  • Jan Hidders
Received on Thu Aug 23 2007 - 23:00:11 CEST

Original text of this message