Better example
Better example
От:
dfm@ringing.org
Дата:
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.
Re: Better example
On Tue, Nov 8, 2016 at 06:01:58PM +0000, dfm@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 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 +
Re: Better example
От:
Don Morrison <dfm@ringing.org>
Дата:
On Wed, Nov 23, 2016 at 12:59 PM, Bruce Momjian <bruce@momjian.us> wrote:
> Is the attached patch what you are suggesting?
Yup, b is what I had in mind.
Thanks!
--
Don Morrison <dfm@ringing.org>
"Nobody minds having what is too good for them."
-- Jane Austen, _Mansfield Park_
Re: [DOCS] Better example
От:
Bruce Momjian <bruce@momjian.us>
Дата:
On Wed, Nov 23, 2016 at 12:59:41PM -0500, Bruce Momjian wrote: > On Tue, Nov 8, 2016 at 06:01:58PM +0000, dfm@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? Patch applied. --------------------------------------------------------------------------- > > -- > Bruce Momjian 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 UPDATE table SET x = 'Infinity'</>. On input, > these strings are recognized in a case-insensitive manner. > > > --- 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 UPDATE table SET x = '-Infinity'</>. On input, > these strings are recognized in a case-insensitive manner. > > > > -- > Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-docs -- Bruce Momjian 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 +