Lists: | pgsql-docs |
---|
From: | dfm(at)ringing(dot)org |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | Better example |
Date: | 2016-11-08 18:01:58 |
Message-ID: | [email protected] |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Lists: | pgsql-docs |
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.
From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | dfm(at)ringing(dot)org |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: Better example |
Date: | 2016-11-23 17:59:41 |
Message-ID: | [email protected] |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Lists: | pgsql-docs |
On Tue, Nov 8, 2016 at 06:01:58PM +0000, dfm(at)ringing(dot)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 <bruce(at)momjian(dot)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 +
Attachment | Content-Type | Size |
---|---|---|
infinity.diff | text/x-diff | 1017 bytes |
From: | Don Morrison <dfm(at)ringing(dot)org> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: Better example |
Date: | 2016-11-23 18:40:45 |
Message-ID: | CAO9hiFWJThkfaPa7cXbwq=Shz=TBtbsWHmk9drnVGO0+DMT8=w@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Lists: | pgsql-docs |
On Wed, Nov 23, 2016 at 12:59 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Is the attached patch what you are suggesting?
Yup, b is what I had in mind.
Thanks!
--
Don Morrison <dfm(at)ringing(dot)org>
"Nobody minds having what is too good for them."
-- Jane Austen, _Mansfield Park_
From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | dfm(at)ringing(dot)org |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: Better example |
Date: | 2017-03-21 02:22:23 |
Message-ID: | [email protected] |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Lists: | pgsql-docs |
On Wed, Nov 23, 2016 at 12:59:41PM -0500, Bruce Momjian wrote:
> On Tue, Nov 8, 2016 at 06:01:58PM +0000, dfm(at)ringing(dot)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 <bruce(at)momjian(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-docs
--
Bruce Momjian <bruce(at)momjian(dot)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 +