Re: NULL/0

David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com> writes:
> Does anyone know what the SQL standard say (or doesn't say) about
> division by zero for NULL?

You mean NULL/0 ?

SQL99 6.26 <numeric value expression> saith:

General Rules

1) If the value of any <numeric primary> simply contained in a
<numeric value expression> is the null value, then the result of
the <numeric value expression> is the null value.

...

4) The dyadic arithmetic operators <plus sign>, <minus sign>,
<asterisk>, and <solidus> (+, -, *, and /, respectively)
specify addition, subtraction, multiplication, and division,
respectively. If the value of a divisor is zero, then an
exception condition is raised: data exception - division by
zero.

Given the order of those statements, I'd expect NULL/0 to yield NULL.

regards, tom lane