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 1f36IR-0001Dh-AR for pgsql-docs@arkaria.postgresql.org; Mon, 02 Apr 2018 20:43:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f36IO-0006ti-PO for pgsql-docs@arkaria.postgresql.org; Mon, 02 Apr 2018 20:43: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 1f36HI-0004Qb-LI for pgsql-docs@lists.postgresql.org; Mon, 02 Apr 2018 20:42:08 +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 1f36HD-0001cN-Oo for pgsql-docs@lists.postgresql.org; Mon, 02 Apr 2018 20:42:07 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1f36H9-0008Bg-Ij; Mon, 02 Apr 2018 16:41:59 -0400 Date: Mon, 2 Apr 2018 16:41:59 -0400 From: Bruce Momjian To: Peter Eisentraut Cc: Euler Taveira , scott.ure@caseware.com, pgsql-docs@lists.postgresql.org Subject: Re: "IS NOT DOCUMENT" is missing Message-ID: <20180402204159.GA30362@momjian.us> References: <152056505045.4963.16783351661813640274@wrigleys.postgresql.org> <20180330144007.GH8476@momjian.us> 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 Mon, Apr 2, 2018 at 11:51:50AM -0400, Peter Eisentraut wrote: > On 3/30/18 10:40, Bruce Momjian wrote: > > 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 > > Per the nearby discussion, this should probably also be backpatched further. OK, backpatched through 9.3. -- 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 +