Commit897313e

committed

Add a note pointing out that some other databases make GREATEST and

LEAST handle NULL arguments differently than we do. Per a discussionon 30-Jun that somehow didn't get done.

1 parentb973530 commit897313eCopy full SHA for 897313e

File tree

-2

lines changed

-2

lines changed

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.405 2007/10/25 18:54:03 tgl Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.406 2007/10/30 19:06:56 tgl Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="functions">`
`4`	`4`	`<title>Functions and Operators</title>`
`@@ -9016,7 +9016,9 @@ SELECT NULLIF(value, '(none)') ...`
`9016`	`9016`
`9017`	`9017`	`<para>`
`9018`	`9018`	`Note that <function>GREATEST</> and <function>LEAST</> are not in`
`9019`		`- the SQL standard, but are a common extension.`
	`9019`	`+ the SQL standard, but are a common extension. Some other databases`
	`9020`	`+ make them return NULL if any argument is NULL, rather than only when`
	`9021`	`+ all are NULL.`
`9020`	`9022`	`</para>`
`9021`	`9023`	`</sect2>`
`9022`	`9024`	`</sect1>`

Comments

(0)