MIME-Version: 1.0
In-Reply-To: <152056505045.4963.16783351661813640274@wrigleys.postgresql.org>
References: <152056505045.4963.16783351661813640274@wrigleys.postgresql.org>
From: Euler Taveira <euler@timbira.com.br>
Date: Fri, 16 Mar 2018 01:56:32 -0300
Message-ID: 
 <CAHE3wgiwDCwnS9QUZKAU0Pb_50FsXxLLy=XYB8oRcNkHpyU3Lg@mail.gmail.com>
Subject: Re: "IS NOT DOCUMENT" is missing
To: scott.ure@caseware.com, pgsql-docs@lists.postgresql.org
Content-Type: multipart/mixed; boundary="000000000000a9579e0567806e9d"
Precedence: bulk

--000000000000a9579e0567806e9d
Content-Type: text/plain; charset="UTF-8"

2018-03-09 0:10 GMT-03:00 PG Doc comments form <noreply@postgresql.org>:
> 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.


-- 
   Euler Taveira                                   Timbira -
http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

--000000000000a9579e0567806e9d
Content-Type: text/x-patch; charset="US-ASCII"; name="doc3.diff"
Content-Disposition: attachment; filename="doc3.diff"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_jetgujru0

ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9mdW5jLnNnbWwgYi9kb2Mvc3JjL3NnbWwvZnVuYy5z
Z21sCmluZGV4IDJmNTlhZjIuLmZjZWYyNDYgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9mdW5j
LnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL2Z1bmMuc2dtbApAQCAtMTAzOTksNiArMTAzOTksMjQg
QEAgU0VMRUNUIHhtbGFnZyh4KSBGUk9NIChTRUxFQ1QgKiBGUk9NIHRlc3QgT1JERVIgQlkgeSBE
RVNDKSBBUyB0YWI7CiAgICAgPC9wYXJhPgogICAgPC9zZWN0Mz4KIAorICAgPHNlY3QzPgorICAg
IDx0aXRsZT48bGl0ZXJhbD5JUyBOT1QgRE9DVU1FTlQ8L2xpdGVyYWw+PC90aXRsZT4KKworICAg
IDxpbmRleHRlcm0+CisgICAgIDxwcmltYXJ5PklTIE5PVCBET0NVTUVOVDwvcHJpbWFyeT4KKyAg
ICA8L2luZGV4dGVybT4KKworPHN5bm9wc2lzPgorPHJlcGxhY2VhYmxlPnhtbDwvcmVwbGFjZWFi
bGU+IElTIE5PVCBET0NVTUVOVAorPC9zeW5vcHNpcz4KKworICAgIDxwYXJhPgorICAgICBUaGUg
ZXhwcmVzc2lvbiA8bGl0ZXJhbD5JUyBOT1QgRE9DVU1FTlQ8L2xpdGVyYWw+IHJldHVybnMgZmFs
c2UgaWYgdGhlCisgICAgIGFyZ3VtZW50IFhNTCB2YWx1ZSBpcyBhIHByb3BlciBYTUwgZG9jdW1l
bnQsIHRydWUgaWYgaXQgaXMgbm90ICh0aGF0IGlzLAorICAgICBpdCBpcyBhIGNvbnRlbnQgZnJh
Z21lbnQpLCBvciBudWxsIGlmIHRoZSBhcmd1bWVudCBpcyBudWxsLgorICAgIDwvcGFyYT4KKyAg
IDwvc2VjdDM+CisKICAgIDxzZWN0MyBpZD0ieG1sLWV4aXN0cyI+CiAgICAgPHRpdGxlPjxsaXRl
cmFsPlhNTEVYSVNUUzwvbGl0ZXJhbD48L3RpdGxlPgogCg==
--000000000000a9579e0567806e9d--