Commitfe2f878

Thomas G. Lockhart

committed

Fix (mis)information about NULLIF() SQL function.

Thanks to Tom Lane for pointing it out.

1 parentf7e12db commitfe2f878Copy full SHA for fe2f878

File tree

-4

lines changed

-4

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -45,10 +45,10 @@`
`45`	`45`	`class="parameter">c2</replaceable> + 5, 0) </entry>`
`46`	`46`	`</row>`
`47`	`47`	`<row>`
`48`		`-<entry>IFNULL(<replaceable class="parameter">input</replaceable>,<replaceable class="parameter">non-NULL substitute</replaceable>) </entry>`
`49`		`-<entry>non-NULL </entry>`
`50`		`-<entry> returnsecond argumentiffirst 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> orNULL </entry>`
	`50`	`+<entry> returnNULLif<replaceable class="parameter">input</replaceable> = <replaceable class="parameter">value</replaceable> </entry>`
	`51`	`+<entry>NULLIF(<replaceable class="parameter">c1</replaceable>, 'N/A')</entry>`
`52`	`52`	`</row>`
`53`	`53`	`<row>`
`54`	`54`	`<entry> CASE WHEN <replaceable class="parameter">expr</replaceable> THEN <replaceable class="parameter">expr</replaceable> [...] ELSE <replaceable class="parameter">expr</replaceable> END </entry>`

Comments

(0)