10000 Add a note pointing out that some other databases make GREATEST and · postgres/postgres@897313e · GitHub
[go: up one dir, main page]
Skip to content

Commit 897313e

Browse files
tglsfdctglsfdc
committed
Add a note pointing out that some other databases make GREATEST and
LEAST handle NULL arguments differently than we do. Per a discussion on 30-Jun that somehow didn't get done.
1 parent b973530 commit 897313e

File tree

1 file changed

+4
-2
lines changed

1 file changed

+4
-2
lines changed

‎doc/src/sgml/func.sgml

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff 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 $ -->
22

33
<chapter id="functions">
44
<title>Functions and Operators</title>
@@ -9016,7 +9016,9 @@ SELECT NULLIF(value, '(none)') ...
90169016

90179017
<para>
90189018
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.
90209022
</para>
90219023
</sect2>
90229024
</sect1>

0 commit comments

Comments
 (0)
0