From 692ed0567d0a17013b8bc631ad6cab29470a944d Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 20 Mar 2017 22:22:11 -0400 Subject: [PATCH] doc: adjust 'Infinity' example to include minus This clarifies that quoted infinity values must have the negative signs inside single quotes. Reported-by: Don Morrison --- doc/src/sgml/datatype.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index e2f8dee7b6..7a546a0399 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -756,7 +756,7 @@ FROM generate_series(-3.5, 3.5, 1) as x; floating-point arithmetic does not follow IEEE 754, these values will probably not work as expected.) When writing these values as constants in an SQL command, you must put quotes around them, - for example UPDATE table SET x = 'Infinity'. On input, + for example UPDATE table SET x = '-Infinity'. On input, these strings are recognized in a case-insensitive manner. -- 2.40.0