Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f1vCT-0001Ji-0v for pgsql-docs@arkaria.postgresql.org; Fri, 30 Mar 2018 14:40:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f1vCS-0007jv-04 for pgsql-docs@arkaria.postgresql.org; Fri, 30 Mar 2018 14:40:16 +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.89) (envelope-from ) id 1f1vCR-0007jk-QS for pgsql-docs@lists.postgresql.org; Fri, 30 Mar 2018 14:40:15 +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.89) (envelope-from ) id 1f1vCO-00007U-Pq for pgsql-docs@lists.postgresql.org; Fri, 30 Mar 2018 14:40:15 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1f1vCJ-0001QY-PK; Fri, 30 Mar 2018 10:40:07 -0400 Date: Fri, 30 Mar 2018 10:40:07 -0400 From: Bruce Momjian To: Euler Taveira Cc: scott.ure@caseware.com, pgsql-docs@lists.postgresql.org Subject: Re: "IS NOT DOCUMENT" is missing Message-ID: <20180330144007.GH8476@momjian.us> References: <152056505045.4963.16783351661813640274@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, Mar 16, 2018 at 01:56:32AM -0300, Euler Taveira wrote: > 2018-03-09 0:10 GMT-03:00 PG Doc comments form : > > From testing, it seems like PostgreSQL supports the syntax "IS NOT DOCUMENT" > > in addition to "IS DOCUMENT", similar to "IS NOT NULL", "IS NOT FALSE", etc, > > however this does not appear to be documented, only "IS DOCUMENT" is. > > > It has been like that since day 1. I'm not sure why it was not > documented. It already has some tests. I'll bet that was an oversight. > Should we repeat the statement in another item (like the attached > patch)? Another option is to add a statement in the "IS DOCUMENT" > item. I'm afraid that NULL return wouldn't be clear. > Patch applied and backpatched to Postgres 10. Thank.s -- 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 +