Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP7ED-0002nO-Nu for pgsql-docs@arkaria.postgresql.org; Tue, 20 Nov 2018 14:42:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gP7EB-0000MM-69 for pgsql-docs@arkaria.postgresql.org; Tue, 20 Nov 2018 14:42:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP7EA-0000IT-TD for pgsql-docs@lists.postgresql.org; Tue, 20 Nov 2018 14:42:11 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP7E3-0005QC-Nf for pgsql-docs@lists.postgresql.org; Tue, 20 Nov 2018 14:42:09 +0000 Received: from pool-71-190-177-59.nycmny.fios.verizon.net ([71.190.177.59] helo=Ph33r-Retina.home) by meldrar.postgresql.org with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP7Dy-0007T4-ME; Tue, 20 Nov 2018 14:42:01 +0000 Subject: Re: Documentation for create unique index is insuficient and (because of that) incorrect To: Bruce Momjian , emilioplatzer@gmail.com, pgsql-docs@lists.postgresql.org References: <154031939560.30897.14677735588262722042@wrigleys.postgresql.org> <20181120020542.GH28656@momjian.us> From: "Jonathan S. Katz" Openpgp: preference=signencrypt Autocrypt: addr=jkatz@postgresql.org; keydata= xsFNBFtShwABEAC7PNHDUOTYuifpUCk23KqfxdQQkn4nkoxOXRK0+rAj36FiwqGB4TJFuOVZ sDFAEiSlC8Jt4y5Cs7B5tetT8JNd2cs6zp/udMJJDz9d65O9PDpdlMgAmIiTzpLlSdx8FG56 DTksaDv1d8j3cTJPSE4/fWSxqzA7o3Y9UuL7atZPrzfImgpRKs0of7elIHwOa8GucjyhYqcR h60wFBJc2KXqQdDYRTZy43DSnY/0VNc0omiH355fustvpm+m5HjD3w7qZyfN3fpKJpnX1LCF f3MnPHaDGITIYGRCBXvf0UqUtD6OEVWPv2C2gyqWMIpWmZTOgDufltKyIByKBoS9x0PlFkij 04X3KODCngt+N8Ssc9OICc6QSxhjoP48PYPdmiTmkrGuf0LX084wj1xeo1NX7XxZK39F6dTJ DhsIiW0sNS0xMxQHLHG9VLbPjx3SANQBh6BuryPz5ZupW9/TIDmkvprtU/oXfKgtfYm3fxmk EctxbWrEPsFTFPyuMqQu6l+xyQv0s1VLZfjNWaua6H1/gGoIt6kRnn5qMXDVVpijuWkHbv7G ngaQMd258UrrOEHnnjzhQ7jxMWV9D+emxbAtlIxnYvCWlV4IwAQhEHfvudqYaIY3hNWrvQ6H GB2KXoTZYN9g5djm14/5nj1IU5zOcovkjJnKhoo9iStnpFF2cwARAQABzTFKb25hdGhhbiBT LiBLYXR6IDxqb25hdGhhbi5rYXR6QGV4Y292ZW50dXJlcy5jb20+wsGXBBMBCABBAhsDBQkH hh+ABQsJCAcCBhUKCQgLAgQWAgMBAh4BAheAFiEE+oS2la8r95ogZD/x8QSccp8cZScFAltS iSUCGQEACgkQ8QSccp8cZSfqrQ//bcMXxIqELT+DMa2C5IR4K3kRsdgxC2mcdsO4XgRxNLQF uZYqKa85EEZ+O4O/oHV5AgckWRcxCUNI0qafwC+QNTc/lBecmMipbP1X2+A8RBiTBRpSgo9y BOQ2xmA70k32Rk4hLd9EVTb0eXe9DoJIXWOsMlqqpqEuXiaoH5a2Ww6DdpCMN1vQZ/HavbAG cXV3MXahiqmBhH6Y0v1kZTJYEOCw0w4U1Q/vdUKw9/jv+fidU6I/jafHAxda7pI+dtNOyUtC bmv+9+KreUeBqyBXGmNFDZ4wa4TvYfaw6VV3acNT5KgcefQpd7JlzM+Vq3zz1tnR4C50nEpg DEpf0ANyeZ48v5+M7ycoIbxAHzwzKsiTaVmMDYRdnxmlv18UaWc/wmoI0wFAtcGjfw5KJLQv oolZYP18S0mpH2Q8SxcXbqekDvsHVW04Jkult9xZSeijdzUzcumflCZ2Y5VQKNjG99eZh5Iq JcUdYJH5mdmdFWgZdYTT6tZWHCMBBDBqktzLmyBezrqT0+j3E5lL/30tkatrcDkNPd3lE/j1 OxG10xVvCqzBvksBR0VX/RLKmj2wvIMqKoCav1GgBIdVAuLSO4CyWkWRRawpcREwUvNKyL2E uPXqsqTzYrYRxUM7GmjY3x40/IiA0uJCuxYEIeelmOwFEnadvyFUJxseVsczl/DOwU0EW1KH AAEQAL/IaP7aEPQxt4+H/YfZ9WkR69hZb4jdlLacui/PnXw4IDtIHopZpBkDqJWdhOtIBn8n v5FLRfVtzQcjuIcQ0fbuqmzl3Hap7gPnHOvBH6pVhSa1bWBcbdIeBJVmDmJyHsyrYa4lnIfx WO9BRq8bN8/FBzh6udMAVuN93k72ZvdFosQYlxLdr9Q4FuFa98pnzuwGqfyGMj7hOCc4LnQL gJdByj8jRB1hxtXQG419UYgsPYJJyA1kDhdAeFAGiXLVhlXJ2dwNlC8DRjGtT/WSZQVn9b3I 9NWohzFNMkOyYyYkqb35vXjNLki8EXQ6yY8peWWalbpo3b9kjDUPBr2EWxDMrNxhg0rfc14H wklJz5yX2MY8wR0SOseOFn7MfEuoVsXqTqIAiSf4OuwZPZmPGFeJJViFwyVTi+Y5wQtPQ27G RvNSWhNkMQfGO1t+mTK6IvVzMYN7PNOYUAEFL3Rv6aFPITfAVna505v/uHkEKe4A2NXjw5hj OmyQvjhzkpxbUf3/u9M6SiddHHO3AcoBp5dckdyo4RcgFlBbz+GRs4ignKTMF2X3vTxrsgP2 DrmzKYcSJ92LCtsK3X2imWF9hjGQmYTDHL8fSKUK8SCYFPlZcF7vzvi5NdFSD3MTyScJqXSO h83EvGYBuiDHAuOOF107i2j/I9poHDL2GpN0nAspABEBAAHCwXwEGAEIACYWIQT6hLaVryv3 miBkP/HxBJxynxxlJwUCW1KHAAIbDAUJB4YfgAAKCRDxBJxynxxlJ0XjD/0QNlIRkI/huLgb IZES46UcrGm3T6oEAXRAZOsGG4qPPFoP9v4YGO1M5gwxMF97GX0A3KyOvryKGyPLqrLWSA/l oAAGtSS3woTMlUJ0stM31jDgAV7HHObRrrxUWbyZJU4rLDBY11MGkRBCqeGYpE7yf+tjAo0n ba1IZzy76E7B0ykSg4nIRPm+QOeGpcLLm04o8Ndjujdtq+SI2YokmVdLu3bEocisPu8Akmsf X7gaBONzTGH/nZ4zCp3qwEGFHGVmDJ5PhAvEWqmAMb+l2drSsdQJBhpLcJECAcK8/SJQ0ryd y1idlCCLi0U3Z4DYIBiC+M87lGtheeharJECLmDGjRE5Oi2H2pQQ0Ok1SwHIAj0MaeJOIvz0 bGd5WdmYUR0WHIjr5pKfiOhHx8JZUKWK1rNbYZbgRqpSUlSYCpdCDhbyi7EOiin6swMIehca zuamo6eL4jSILVqBcDuQadI4BU2x9jqzFiEX1HVAh9Q427qOubL4TY+xTbEFWMxwyPjXdSPy zgaD3N1KK0TBdjOCVZFEe7JDh1lGz00jVK+6nNeDUjGNzyoxnlRgLAVRwT75kcf0rNrVv06S VqcYOKZqrhUEl7mmIWH+BTfEsct9tKXK/hajfAIWZGCXDWPNjk7UeVRCkQv5mHMqutalyCqp 4MnZ+/WyYxsR4qcchRZhAg== Message-ID: <9ba37df7-156b-b983-65b5-85ed096818b9@postgresql.org> Date: Tue, 20 Nov 2018 09:41:56 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:60.0) Gecko/20100101 Thunderbird/60.3.1 MIME-Version: 1.0 In-Reply-To: <20181120020542.GH28656@momjian.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="eAMj91VefYGreZhD72Oj6h6zlFVTEUvac" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --eAMj91VefYGreZhD72Oj6h6zlFVTEUvac Content-Type: multipart/mixed; boundary="Jdk05WXaE3lkFTXpsoS1UZbyrDYVwLFBp"; protected-headers="v1" From: "Jonathan S. Katz" To: Bruce Momjian , emilioplatzer@gmail.com, pgsql-docs@lists.postgresql.org Message-ID: <9ba37df7-156b-b983-65b5-85ed096818b9@postgresql.org> Subject: Re: Documentation for create unique index is insuficient and (because of that) incorrect References: <154031939560.30897.14677735588262722042@wrigleys.postgresql.org> <20181120020542.GH28656@momjian.us> In-Reply-To: <20181120020542.GH28656@momjian.us> --Jdk05WXaE3lkFTXpsoS1UZbyrDYVwLFBp Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 11/19/18 9:05 PM, Bruce Momjian wrote: > On Tue, Oct 23, 2018 at 06:29:55PM +0000, PG Doc comments form wrote: >> The following documentation comment has been logged on the website: >> >> Page: https://www.postgresql.org/docs/11/static/indexes-unique.html >> Description: >> >> In https://www.postgresql.org/docs/11/static/indexes-unique.html there= are >> omited clausules >> >> For example WHERE clausule is omited.=20 >> >> In https://www.postgresql.org/docs/11/static/sql-createindex.html you = can >> see the right sintax with all the clausules. >=20 > The first URL is an example and is not intended to be the complete > syntax. >=20 In fairness, the "INCLUDE" clause was added, which is new to PostgreSQL 11, so it could raise the question as to why aren't other clauses there. Perhaps we could add some more examples? For instance, why one might want to use "INCLUDE" with a unique index. And perhaps a case of the "partial unique index" (which I have used in production systems before). Thanks! Jonathan --Jdk05WXaE3lkFTXpsoS1UZbyrDYVwLFBp-- --eAMj91VefYGreZhD72Oj6h6zlFVTEUvac Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAlv0HTQACgkQ8QSccp8c ZSdufQ/+IDmePWxgV9uHjH3pYrcCjtpOscGmCwajDwsR/B8c3eOfoIvfEF9nEeSl 2Iwil9NFiT9SPcqMhS/Jq0hMxj6VmbxyOMBjgSxdV/tSmWM5PWrPF2oIs68M3n1s b3/poBtLrtjHjNn4Pl1WlG2yJnoyWSaJz/5OEwmf4VBd/J33zKH4Jqww6xTaS/mZ mjV0W96DpWf2cjhsaumLOSrptl8SsKtH869VdQJuRc706Cv/dePWnyqdyGS+1Z3h GiCS08hm1OJaUzk5fKiMw4T4hcTKd8BejQ7LvNxjRSKW/Q4qHZKfYON+n1x3L33a 40jqY9s+QF/Qg5Cj13PTDMNtxVIq7PxOqxX4bxpcrO6MQuVQ/NwcI04kH7Jk7/mq np3t7G3CYXgEMPDz+305kLzBUxhBc7/oeaak5VurBLjuEZA8fhNM+kFJRHE7fftG Nxb3pNfbrxbhcF+jnGJCXwg160W0h1swtvLim21o5sewPq+iC937y/1yy1IJWxCN 7Y2Y8aEL9OapLZJNVwPErbyBwl+kxrpg0HJB+G+nx3YpmU4DF0FgxJrdNWuDdotl yIH63bpn9hk9fSutp4sgJ0CiFHHR7nSoIfImuz9rrxIBaXrXD7SGyg38oB1IdP8W t6g0pkSDZwJLE2xXR+HEGZPteMJ8IXj9ptdP/h/x9p/lE6d+D3A= =r0s5 -----END PGP SIGNATURE----- --eAMj91VefYGreZhD72Oj6h6zlFVTEUvac--