• Tom Lane's avatar
    Fix IS NULL and IS NOT NULL tests on row-valued expressions to conform to · f213131f
    Tom Lane authored
    the SQL spec, viz IS NULL is true if all the row's fields are null, IS NOT
    NULL is true if all the row's fields are not null.  The former coding got
    this right for a limited number of cases with IS NULL (ie, those where it
    could disassemble a ROW constructor at parse time), but was entirely wrong
    for IS NOT NULL.  Per report from Teodor.
    
    I desisted from changing the behavior for arrays, since on closer inspection
    it's not clear that there's any support for that in the SQL spec.  This
    probably needs more consideration.
    f213131f
execnodes.h 45.2 KB