List: | General Discussion | « Previous MessageNext Message » | |

From: | C.R.Vegelin | Date: | December 6 2006 3:13pm |

Subject: | Re: SUM() of 1 and NULL is 1 ? | ||

View as plain text |

Thanks Visolve, Peter, This is a serious matter, because: - within a row: 1 + NULL = NULL - across rows with SUM(): 1 + NULL = 1 I know the manual says that group functions ignore NULL values (12.10.1), but it also says: Conceptually, NULL means "a missing unknown value" (3.3.4.6). IMHO a NULL with any value should always add to NULL. I was hoping for an option / setting to change NULL behaviour. Well, I will try the suggested alternatives. Thanks, Cor

Thread | ||
---|---|---|

• SUM() of 1 and NULL is 1 ? | C.R.Vegelin | 6 Dec |

• RE: SUM() of 1 and NULL is 1 ? | Peter Lauri | 6 Dec |

• Re: SUM() of 1 and NULL is 1 ? | ViSolve DB Team | 6 Dec |

• Re: SUM() of 1 and NULL is 1 ? | ViSolve DB Team | 6 Dec |

• Re: SUM() of 1 and NULL is 1 ? | Remo Tex | 7 Dec |

• Re: SUM() of 1 and NULL is 1 ? | C.R.Vegelin | 6 Dec |

• Re: SUM() of 1 and NULL is 1 ? | Martijn Tonies | 6 Dec |

• Re: SUM() of 1 and NULL is 1 ? | Peter Brawley | 6 Dec |