Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c9bqA-0000KD-Th for pgsql-docs@arkaria.postgresql.org; Wed, 23 Nov 2016 18:00:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c9bq9-000856-Pb for pgsql-docs@arkaria.postgresql.org; Wed, 23 Nov 2016 18:00:13 +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 1c9bpo-0007dp-4t for pgsql-docs@postgresql.org; Wed, 23 Nov 2016 17:59:52 +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 1c9bpg-0004VW-TS for pgsql-docs@postgresql.org; Wed, 23 Nov 2016 17:59:51 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1c9bpe-0002jh-0M; Wed, 23 Nov 2016 12:59:42 -0500 Date: Wed, 23 Nov 2016 12:59:41 -0500 From: Bruce Momjian To: dfm@ringing.org Cc: pgsql-docs@postgresql.org Subject: Re: Better example Message-ID: <20161123175941.GA8036@momjian.us> References: <20161108180158.27607.28000@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="+HP7ph2BbKc20aGI" Content-Disposition: inline In-Reply-To: <20161108180158.27607.28000@wrigleys.postgresql.org> User-Agent: Mutt/1.5.23 (2014-03-12) X-Pg-Spam-Score: -4.8 (----) 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 --+HP7ph2BbKc20aGI Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 + --+HP7ph2BbKc20aGI Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="infinity.diff" 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. --+HP7ph2BbKc20aGI Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --+HP7ph2BbKc20aGI--