Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cq9RO-0003HU-Cj for pgsql-docs@arkaria.postgresql.org; Tue, 21 Mar 2017 02:22:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cq9RN-0000bc-Vn for pgsql-docs@arkaria.postgresql.org; Tue, 21 Mar 2017 02:22:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cq9RN-0000XB-14 for pgsql-docs@postgresql.org; Tue, 21 Mar 2017 02:22:29 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cq9RK-0005Wo-2X for pgsql-docs@postgresql.org; Tue, 21 Mar 2017 02:22:28 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1cq9RH-00080O-V6; Mon, 20 Mar 2017 22:22:23 -0400 Date: Mon, 20 Mar 2017 22:22:23 -0400 From: Bruce Momjian To: dfm@ringing.org Cc: pgsql-docs@postgresql.org Subject: Re: Better example Message-ID: <20170321022223.GB2045@momjian.us> References: <20161108180158.27607.28000@wrigleys.postgresql.org> <20161123175941.GA8036@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20161123175941.GA8036@momjian.us> User-Agent: Mutt/1.5.23 (2014-03-12) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org 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 + -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs