On Tue, Nov 8, 2016 at 06:01:58PM +0000, d...@ringing.org wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.5/static/datatype-numeric.html
> Description:
>
> I think that in the section on floating point Infinity/-Infinity/NaN in the
> Data Types chapter the example would be better setting it to -Infinity
> rather than positive, as that would make clear that the minus sign needs to
> be within the quote marks. This isn't clear otherwise.
Is the attached patch what you are suggesting?
--
Bruce Momjian <br...@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
new file mode 100644
index 67d0c34..fbc3576
*** a/doc/src/sgml/datatype.sgml
--- b/doc/src/sgml/datatype.sgml
*************** FROM generate_series(-3.5, 3.5, 1) as x;
*** 750,756 ****
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 <literal>UPDATE table SET x = 'Infinity'</>. On input,
these strings are recognized in a case-insensitive manner.
</para>
--- 750,756 ----
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 <literal>UPDATE table SET x = '-Infinity'</>. On input,
these strings are recognized in a case-insensitive manner.
</para>
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
