Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
10.8.2.2
-
None
Description
The section describing NULLIF in the reference manual is a bit cryptic. http://db.apache.org/derby/docs/10.8/ref/rrefcasenullif.html
It says that NULLIF is used for conditional expressions, and that it is similar to CASE, but it doesn't say in plain words how it works. It would be good if it could mention that NULLIF returns NULL if the two arguments are equal, and that it returns the first argument if they are not equal.