[
https://issues.apache.org/jira/browse/DERBY-5557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13251381#comment-13251381
]
Knut Anders Hatlen commented on DERBY-5557:
-------------------------------------------
I agree with Dag that it's probably OK to call COALESCE and NULLIF functions.
CASE, on the other hand, isn't a function, so it might make sense to move "CASE
expression" to the "SQL expressions" topic.
> NULLIF topic in reference manual should explain NULLIF
> ------------------------------------------------------
>
> Key: DERBY-5557
> URL: https://issues.apache.org/jira/browse/DERBY-5557
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.2.2
> Reporter: Knut Anders Hatlen
> Assignee: Kim Haase
> Attachments: DERBY-5557.diff, rrefcasenullif.html
>
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
