Skip to content

Commit fe2f878

Browse files
author
Thomas G. Lockhart
committed
Fix (mis)information about NULLIF() SQL function.
Thanks to Tom Lane for pointing it out.
1 parent f7e12db commit fe2f878

File tree

1 file changed

+4
-4
lines changed

1 file changed

+4
-4
lines changed

doc/src/sgml/func.sgml

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -45,10 +45,10 @@
4545
class="parameter">c2</replaceable> + 5, 0) </entry>
4646
</row>
4747
<row>
48-
<entry> IFNULL(<replaceable class="parameter">input</replaceable>,<replaceable class="parameter">non-NULL substitute</replaceable>) </entry>
49-
<entry> non-NULL </entry>
50-
<entry> return second argument if first is NULL </entry>
51-
<entry> IFNULL(<replaceable class="parameter">c1</replaceable>, 'N/A')</entry>
48+
<entry> NULLIF(<replaceable class="parameter">input</replaceable>,<replaceable class="parameter">value</replaceable>) </entry>
49+
<entry> <replaceable class="parameter">input</replaceable> or NULL </entry>
50+
<entry> return NULL if <replaceable class="parameter">input</replaceable> = <replaceable class="parameter">value</replaceable> </entry>
51+
<entry> NULLIF(<replaceable class="parameter">c1</replaceable>, 'N/A')</entry>
5252
</row>
5353
<row>
5454
<entry> CASE WHEN <replaceable class="parameter">expr</replaceable> THEN <replaceable class="parameter">expr</replaceable> [...] ELSE <replaceable class="parameter">expr</replaceable> END </entry>

0 commit comments

Comments
 (0)