Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nFZiZ-00026L-R4 for pgsql-committers@arkaria.postgresql.org; Thu, 03 Feb 2022 10:51:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nFZiY-0003vr-Ng for pgsql-committers@arkaria.postgresql.org; Thu, 03 Feb 2022 10:51:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nFZiY-0003vQ-GV for pgsql-committers@lists.postgresql.org; Thu, 03 Feb 2022 10:51:58 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nFZiV-0004Xz-FP for pgsql-committers@lists.postgresql.org; Thu, 03 Feb 2022 10:51:57 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nFZiU-0002UG-Pw for pgsql-committers@lists.postgresql.org; Thu, 03 Feb 2022 10:51:54 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nFZiT-0003JZ-T8 for pgsql-committers@lists.postgresql.org; Thu, 03 Feb 2022 10:51:53 +0000 Content-Type: multipart/mixed; boundary="===============8915481165261988944==" MIME-Version: 1.0 From: Peter Eisentraut To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add UNIQUE null treatment option X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 03 Feb 2022 10:51:53 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8915481165261988944== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIFVOSVFVRSBudWxsIHRyZWF0bWVudCBvcHRpb24KClRoZSBTUUwgc3RhbmRhcmQgaGFzIGJl ZW4gYW1iaWd1b3VzIGFib3V0IHdoZXRoZXIgbnVsbCB2YWx1ZXMgaW4KdW5pcXVlIGNvbnN0cmFp bnRzIHNob3VsZCBiZSBjb25zaWRlcmVkIGVxdWFsIG9yIG5vdC4gIERpZmZlcmVudAppbXBsZW1l bnRhdGlvbnMgaGF2ZSBkaWZmZXJlbnQgYmVoYXZpb3JzLiAgSW4gdGhlIFNRTDoyMDJ4IGRyYWZ0 LCB0aGlzCmhhcyBiZWVuIGZvcm1hbGl6ZWQgYnkgbWFraW5nIHRoaXMgaW1wbGVtZW50YXRpb24t ZGVmaW5lZCBhbmQgYWRkaW5nCmFuIG9wdGlvbiBvbiB1bmlxdWUgY29uc3RyYWludCBkZWZpbml0 aW9ucyBVTklRVUUgWyBOVUxMUyBbTk9UXQpESVNUSU5DVCBdIHRvIGNob29zZSBhIGJlaGF2aW9y IGV4cGxpY2l0bHkuCgpUaGlzIHBhdGNoIGFkZHMgdGhpcyBvcHRpb24gdG8gUG9zdGdyZVNRTC4g IFRoZSBkZWZhdWx0IGJlaGF2aW9yCnJlbWFpbnMgVU5JUVVFIE5VTExTIERJU1RJTkNULiAgTWFr aW5nIHRoaXMgaGFwcGVuIGluIHRoZSBidHJlZSBjb2RlCmlzIHByZXR0eSBlYXN5OyBtb3N0IG9m IHRoZSBwYXRjaCBpcyBqdXN0IHRvIGNhcnJ5IHRoZSBmbGFnIGFyb3VuZCB0bwphbGwgdGhlIHBs YWNlcyB0aGF0IG5lZWQgaXQuCgpUaGUgQ1JFQVRFIFVOSVFVRSBJTkRFWCBzeW50YXggZXh0ZW5z aW9uIGlzIG5vdCBmcm9tIHRoZSBzdGFuZGFyZCwKaXQncyBteSBvd24gaW52ZW50aW9uLgoKSSBu YW1lZCBhbGwgdGhlIGludGVybmFsIGZsYWdzLCBjYXRhbG9nIGNvbHVtbnMsIGV0Yy4gaW4gdGhl IG5lZ2F0aXZlCigibnVsbHMgbm90IGRpc3RpbmN0Iikgc28gdGhhdCB0aGUgZGVmYXVsdCBQb3N0 Z3JlU1FMIGJlaGF2aW9yIGlzIHRoZQpkZWZhdWx0IGlmIHRoZSBmbGFnIGlzIGZhbHNlLgoKUmV2 aWV3ZWQtYnk6IE1heGltIE9ybG92IDxvcmxvdm1nQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IFBh dmVsIEJvcmlzb3YgPHBhc2hraW4uZWxmZUBnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8v d3d3LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQvZmxhdC84NGU1ZWUxYi0zODdlLTlhNTQtYzMy Ni05MDgyNjc0YmRlNzhAZW50ZXJwcmlzZWRiLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRl dGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzk0 YWE3Y2M1ZjcwNzcxMmY1OTI4ODU5OTVhMjhlMDE4YzdjODA0ODgKCk1vZGlmaWVkIEZpbGVzCi0t LS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sICAgICAgICAgICAgICAgICB8 IDEzICsrKysrKysKZG9jL3NyYy9zZ21sL2RkbC5zZ21sICAgICAgICAgICAgICAgICAgICAgIHwg MjkgKysrKysrKysrKystLS0KZG9jL3NyYy9zZ21sL2luZm9ybWF0aW9uX3NjaGVtYS5zZ21sICAg ICAgIHwgMTIgKysrKysrCmRvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfdGFibGUuc2dtbCAgICAgICAg ICB8ICA0ICstCmRvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX2luZGV4LnNnbWwgICAgICAgICB8IDEz ICsrKysrKysKZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfdGFibGUuc2dtbCAgICAgICAgIHwgMTEg KysrLS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy9uYnRyZWUvbmJ0aW5zZXJ0LmMgICAgICB8ICA2ICst LQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idHNvcnQuYyAgICAgICAgfCAxNSArKysrKysr LQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idHV0aWxzLmMgICAgICAgfCAgNyArKysrCnNy Yy9iYWNrZW5kL2NhdGFsb2cvaW5kZXguYyAgICAgICAgICAgICAgICB8ICA3ICsrKysKc3JjL2Jh Y2tlbmQvY2F0YWxvZy9pbmZvcm1hdGlvbl9zY2hlbWEuc3FsIHwgIDkgKysrKy0Kc3JjL2JhY2tl bmQvY2F0YWxvZy9zcWxfZmVhdHVyZXMudHh0ICAgICAgIHwgIDEgKwpzcmMvYmFja2VuZC9jYXRh bG9nL3RvYXN0aW5nLmMgICAgICAgICAgICAgfCAgMSArCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2lu ZGV4Y21kcy5jICAgICAgICAgICB8ICAzICstCnNyYy9iYWNrZW5kL25vZGVzL2NvcHlmdW5jcy5j ICAgICAgICAgICAgICB8ICAyICsKc3JjL2JhY2tlbmQvbm9kZXMvZXF1YWxmdW5jcy5jICAgICAg ICAgICAgIHwgIDIgKwpzcmMvYmFja2VuZC9ub2Rlcy9tYWtlZnVuY3MuYyAgICAgICAgICAgICAg fCAgMyArLQpzcmMvYmFja2VuZC9ub2Rlcy9vdXRmdW5jcy5jICAgICAgICAgICAgICAgfCAgMiAr CnNyYy9iYWNrZW5kL3BhcnNlci9ncmFtLnkgICAgICAgICAgICAgICAgICB8IDQ3ICsrKysrKysr KysrKysrLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV91dGlsY21kLmMgICAgICAg ICB8ICAzICsrCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9ydWxldXRpbHMuYyAgICAgICAgICB8IDIz ICsrKysrKystLS0tCnNyYy9iYWNrZW5kL3V0aWxzL2NhY2hlL3JlbGNhY2hlLmMgICAgICAgICB8 ICAxICsKc3JjL2JhY2tlbmQvdXRpbHMvc29ydC90dXBsZXNvcnQuYyAgICAgICAgIHwgIDggKysr LQpzcmMvYmluL3BnX2R1bXAvcGdfZHVtcC5jICAgICAgICAgICAgICAgICAgfCAxOSArKysrKysr Ky0tCnNyYy9iaW4vcGdfZHVtcC9wZ19kdW1wLmggICAgICAgICAgICAgICAgICB8ICAxICsKc3Jj L2Jpbi9wc3FsL2Rlc2NyaWJlLmMgICAgICAgICAgICAgICAgICAgIHwgMTkgKysrKysrKystLQpz cmMvaW5jbHVkZS9jYXRhbG9nL2NhdHZlcnNpb24uaCAgICAgICAgICAgfCAgMiArLQpzcmMvaW5j bHVkZS9jYXRhbG9nL3BnX2luZGV4LmggICAgICAgICAgICAgfCAgMSArCnNyYy9pbmNsdWRlL25v ZGVzL2V4ZWNub2Rlcy5oICAgICAgICAgICAgICB8ICAxICsKc3JjL2luY2x1ZGUvbm9kZXMvbWFr ZWZ1bmNzLmggICAgICAgICAgICAgIHwgIDIgKy0Kc3JjL2luY2x1ZGUvbm9kZXMvcGFyc2Vub2Rl cy5oICAgICAgICAgICAgIHwgIDIgKwpzcmMvaW5jbHVkZS91dGlscy90dXBsZXNvcnQuaCAgICAg ICAgICAgICAgfCAgMSArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY29uc3RyYWludHMub3V0 ICB8IDIzICsrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY3JlYXRlX2luZGV4 Lm91dCB8IDYxICsrKysrKysrKysrKysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNz L3NxbC9jb25zdHJhaW50cy5zcWwgICAgICAgfCAxNCArKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mv c3FsL2NyZWF0ZV9pbmRleC5zcWwgICAgICB8IDM3ICsrKysrKysrKysrKysrKysrKwozNiBmaWxl cyBjaGFuZ2VkLCAzNDggaW5zZXJ0aW9ucygrKSwgNTcgZGVsZXRpb25zKC0pCgo= --===============8915481165261988944==--