|< < 4 > >|

Unknown values and NULL

  • Sometimes a value is unknown.

  • The value NULL can be stored to represent such a value.

  • What about computation with NULL? E.g. what are the values of these expressions:
    • 3 + NULL
    • NULL < 5
    • true and NULL
    • false and NULL
    • NULL = NULL

    • |< < 4 > >|