diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1999-09-29 05:20:20 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1999-09-29 05:20:20 +0000 |
| commit | fe2f878173cdb4b9ad4d70ad9d979d06a5d5df58 (patch) | |
| tree | 3e5cff9c2a2f5763a7cad0c67c4ebf410b8229fa /doc/src | |
| parent | f7e12db734e9de82d3fe34e228b5b5dc8ef559aa (diff) | |
Fix (mis)information about NULLIF() SQL function.
Thanks to Tom Lane for pointing it out.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 492859f56b6..2bfec9272e5 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -45,10 +45,10 @@ class="parameter">c2</replaceable> + 5, 0) </entry> </row> <row> - <entry> IFNULL(<replaceable class="parameter">input</replaceable>,<replaceable class="parameter">non-NULL substitute</replaceable>) </entry> - <entry> non-NULL </entry> - <entry> return second argument if first is NULL </entry> - <entry> IFNULL(<replaceable class="parameter">c1</replaceable>, 'N/A')</entry> + <entry> NULLIF(<replaceable class="parameter">input</replaceable>,<replaceable class="parameter">value</replaceable>) </entry> + <entry> <replaceable class="parameter">input</replaceable> or NULL </entry> + <entry> return NULL if <replaceable class="parameter">input</replaceable> = <replaceable class="parameter">value</replaceable> </entry> + <entry> NULLIF(<replaceable class="parameter">c1</replaceable>, 'N/A')</entry> </row> <row> <entry> CASE WHEN <replaceable class="parameter">expr</replaceable> THEN <replaceable class="parameter">expr</replaceable> [...] ELSE <replaceable class="parameter">expr</replaceable> END </entry> |