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 1gLAGd-0000e4-VO for pgsql-sql@arkaria.postgresql.org; Fri, 09 Nov 2018 17:08:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gLAGc-0002dH-He for pgsql-sql@arkaria.postgresql.org; Fri, 09 Nov 2018 17:08:22 +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 1gLAGc-0002d1-Ad for pgsql-sql@lists.postgresql.org; Fri, 09 Nov 2018 17:08:22 +0000 Received: from relays-agent05.techservices.illinois.edu ([192.17.82.72] helo=illinois.edu) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gLAGa-0003H7-08 for pgsql-sql@postgresql.org; Fri, 09 Nov 2018 17:08:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=illinois.edu; h=from : to : cc : subject : date : message-id : references : in-reply-to : content-type : content-id : content-transfer-encoding : mime-version; s=campusrelays; bh=c4Q7CZgZcYwbV92kEp1MiPAbj7K2O4y5Unn90g/YMbc=; b=Hu1BFmr5ztnQZjHaaE77Rs65jp/kMzV1EXmUROOjdBScO0sn9U7SrxBmb4sbcBVNpcpb 9YHuy+djbpmK3gv/wvxi1un5L29/QerfAlj/U0fMYBAyIDPefHkCLBa8kuddKnsChjQY 2mequA1VSIi/X+q43mlcDVWYywYOc5igcWUiVUDTPrN+Jec6z1E+6eK/qc1S2lvNu00T KJJ5CenjmFwuxn1f5I/5ROwMK8MrAVq8gTJT6J7l8qfxlZ4GVWCBB3sTFw4JMx1dYvcP B8iN3fBV6kPm+pZdxUCGl6i36zHUjtIVPs8Z4AkmMxjrK74XruE8KmC3VF3WYqFMeDbS Kg== Received: from NAM04-SN1-obe.outbound.protection.outlook.com (mail-sn1nam04lp0086.outbound.protection.outlook.com [216.32.180.86]) by relays-agent05.techservices.illinois.edu (8.16.0.22/8.16.0.22) with ESMTPS id wA9H89IJ005226 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=NOT); Fri, 9 Nov 2018 11:08:13 -0600 Received: from DM5PR11MB1484.namprd11.prod.outlook.com (10.172.36.143) by DM5PR11MB1497.namprd11.prod.outlook.com (10.172.36.144) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.1294.27; Fri, 9 Nov 2018 17:08:08 +0000 Received: from DM5PR11MB1484.namprd11.prod.outlook.com ([fe80::1c4c:4e21:880:e334]) by DM5PR11MB1484.namprd11.prod.outlook.com ([fe80::1c4c:4e21:880:e334%5]) with mapi id 15.20.1294.034; Fri, 9 Nov 2018 17:08:08 +0000 From: "Campbell, Lance" To: "David G. Johnston" CC: pgsql-sql Subject: Re: Help with a not match Thread-Topic: Help with a not match Thread-Index: AQHUeEvF8v974QkML0WvGKQlXVcq6KVHqSOA//+fQYA= Date: Fri, 9 Nov 2018 17:08:08 +0000 Message-ID: <47589FBF-7910-4F95-8239-BDF702A19B2C@illinois.edu> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/10.10.3.181015 x-originating-ip: [128.174.117.141] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;DM5PR11MB1497;6:nNB+toKHA5nQYek+2YwBTW6HoOm0U2lxdS5xq4WV4JV+NW3ueI8S4lGHWgL61+dJrGajQjvT0LduZn9lxVt5Sn+mLbaFyVP/Da9vRxfbv0Toyad45hPq9MCMF7Sgmj15gPmeR8JuyhTKaQP6AEBQfMDUJslkRqAE3CLUxFNJgMEaDUS1d7+OIBY7QROQ/5tixTOZac//kVx4nstaw9QMX1F8RQ5dETkpLGzWE2D3Orv7Ajk8cYwu5vteylpNmZW/hoYbW/usy/uLDowL3zOKHcK6P5svnrD6U7lojqvB4OYR4tO5XC7xQycZvLpW/phx5JT7RtEk+r4rYknS7p6R/1aV5g1aLeNzX5ASemrQCst8i9GurOfAX00biia/9oAr6fKwhycpATsbZF/YqGLLLY0dpiBLDkUzPoGzKomXRuNlGVVXikSaNoutYidNLhuWPpHEStOjyRBvddQ1bJswRQ==;5:mRt4ano2T8G693UTVKOY7ufeyc8JemXpf8iB2Rw1cMP4l5Td+CYnjU0MgpNbzlq8cLUea9SKWERUfdAT1AAqX/sZ7OIhsIvf3tKHl0Xf7aZ3JNn8L8DuzEegSSFQga7dTUu2sIMc57hosSFhcGBmNMFst1GClr81Z6ECl+NE3mU=;7:g1Sfs+RwL8zI3cS3g6foNGSbFjIXhWN7auI8dlx3MqRUu9gPyZmqGj72PofTtK/yOcb2tIEBW5XWsIjyXFKYk+TVP+2wl74/Z4sFXC1WQIZLLwraMZhyil0EBRPCTX1xKTeq5+b1GcmH3hY8W1QUJQ== x-ms-exchange-antispam-srfa-diagnostics: SOS; x-ms-office365-filtering-correlation-id: ee0c6b65-3041-445f-a628-08d64665ec1c x-microsoft-antispam: BCL:0;PCL:0;RULEID:(7020095)(4652040)(8989299)(5600074)(711020)(4534185)(4627221)(201703031133081)(201702281549075)(8990200)(2017052603328)(7153060)(7193020);SRVR:DM5PR11MB1497; x-ms-traffictypediagnostic: DM5PR11MB1497: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(85827821059158)(29773736570271); x-ms-exchange-senderadcheck: 1 x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040522)(2401047)(5005006)(8121501046)(93006095)(93001095)(10201501046)(3002001)(3231382)(944501410)(52105095)(148016)(149066)(150057)(6041310)(20161123560045)(20161123564045)(20161123558120)(20161123562045)(201703131423095)(201702281529075)(201702281528075)(20161123555045)(201703061421075)(201703061406153)(201708071742011)(7699051)(76991095);SRVR:DM5PR11MB1497;BCL:0;PCL:0;RULEID:;SRVR:DM5PR11MB1497; x-forefront-prvs: 08512C5403 x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(346002)(376002)(39860400002)(136003)(396003)(366004)(199004)(189003)(316002)(71190400001)(186003)(486006)(476003)(11346002)(58126008)(446003)(2616005)(97736004)(66066001)(75432002)(76176011)(82746002)(25786009)(86362001)(83716004)(99286004)(256004)(71200400001)(786003)(26005)(39060400002)(102836004)(478600001)(53546011)(6506007)(5660300001)(2906002)(6116002)(3846002)(6916009)(36756003)(105586002)(106356001)(305945005)(4326008)(7736002)(8936002)(68736007)(88552002)(6486002)(81156014)(81166006)(33656002)(8676002)(6436002)(6512007)(53936002)(229853002)(2900100001)(6246003)(14454004);DIR:OUT;SFP:1101;SCL:1;SRVR:DM5PR11MB1497;H:DM5PR11MB1484.namprd11.prod.outlook.com;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;A:1;MX:1; received-spf: None (protection.outlook.com: illinois.edu does not designate permitted sender hosts) x-microsoft-antispam-message-info: amho3KZ4FFzqmVA2f6ILvV6hmjDpMshmFRWqdZysVZXI3S6ATLlTh9YJsl1wqQ/0SW+54pqJHqhG5HRS2Wke/ofIpwFzlimRpy1UnHFS1ymdlhRDaiM8UOBhGDYb/b5Lop7mih2BMCnN+C2cs46awBy+GzFZTB8gR7vkuaQ7ay1ifI0+J70p0/ZIQpuK0REK9WUvTx7qgEWGIhGBmKhSY/xr+4tNfuIg+rNcI/jDqRHQz925F2xE7cgcqwYm3Sgo/HrP7M6YBW2BCYW15BJyCF6fPmvEZn7XPIzWMY/gLl2TgcjlPmkgdX6uW8A5oQErN6hEzGBM3tmeoUu5jUSsREMP4mddr/jeECB6rOt29T8= spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: illinois.edu X-MS-Exchange-CrossTenant-Network-Message-Id: ee0c6b65-3041-445f-a628-08d64665ec1c X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Nov 2018 17:08:08.5104 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 44467e6f-462c-4ea2-823f-7800de5434e3 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM5PR11MB1497 X-Spam-Details: rule=cautious_plus_nq_notspam policy=cautious_plus_nq score=0 priorityscore=1501 malwarescore=0 suspectscore=0 phishscore=0 bulkscore=0 spamscore=0 clxscore=1011 lowpriorityscore=0 mlxscore=0 impostorscore=0 mlxlogscore=999 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1807170000 definitions=main-1811090156 X-Spam-Score: 0 X-Spam-OrigSender: lance@illinois.edu X-Spam-Bar: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SSBhbSB0cnlpbmcgdG8gZmluZCBJRHMgd2hlcmUgdGhlIGZpZWxkIGNvbnRlbnQgY29udGFpbiBp bXByb3BlciBzdWJzdHJpbmdzLiAgDQoNCkkgd2FudCBzb21ldGhpbmcgbGlrZSB0aGlzOg0KU0VM RUNUIGlkIGZyb20gdGFibGVBIFdIRVJFIGNvbnRlbnQgTElLRSAiJWZpbGVzLyIgfHwge3NvbWUg bnVtYmVyIHRoYXQgZG9lcyBub3QgbWF0Y2ggdGhlIElEfSB8fCAiLyUiIA0KDQpJIGRvbid0IGtu b3cgaG93IHRvIHdyaXRlIHRoaXMuDQoNClRoZSBTUUwgeW91IHByb3ZpZGVkIGlzIHRoZSBvcHBv c2l0ZSBvZiB3aGF0IEkgd2FzIGxvb2tpbmcgZm9yLiAgVGhhbmtzIHRob3VnaC4NCg0KTGFuY2Ug DQoNCu+7v09uIDExLzkvMTgsIDEwOjU0IEFNLCAiRGF2aWQgRy4gSm9obnN0b24iIDxkYXZpZC5n LmpvaG5zdG9uQGdtYWlsLmNvbT4gd3JvdGU6DQoNCiAgICBPbiBGcmksIE5vdiA5LCAyMDE4IGF0 IDk6NDYgQU0gQ2FtcGJlbGwsIExhbmNlIDxsYW5jZUBpbGxpbm9pcy5lZHU+IHdyb3RlOg0KICAg ID4gVXNlIGNhc2U6DQogICAgPiBJIGhhdmUgYSB0YWJsZSBJIHdpbGwgY2FsbCDigJx0YWJsZUHi gJ0uICBJdCBoYXMgdHdvIGNvbHVtbnMuICBPbmUgY29sdW1uIGlzIGFuIOKAnGlk4oCdIHRoYXQg aXMgYW4gaW50ZWdlciBwcmltYXJ5IGtleS4gIFRoZSBzZWNvbmQgZmllbGQgaXMgYSB0ZXh0IGZp ZWxkIGNhbGxlZCDigJxjb250ZW504oCdLg0KICAgID4gSW4gdGhlIOKAnGNvbnRlbnTigJ0gZmll bGQgdGhlcmUgbWF5IG9yIG1heSBub3QgYmUgdGhpcyBzdWJzdHJpbmcg4oCcL2ZpbGVzL3tpZH0v 4oCdIC4gIE5vdGUgdGhhdCB7aWR9IHJlcHJlc2VudHMgdGhlIGZpZWxkIGlkIGZvciB0aGF0IHJl Y29yZC4gIEkgd2FudCB0byBmaW5kIGFueSByb3dzIHdoZXJlIGNvbnRlbnQgY29udGFpbnMg4oCc L2ZpbGVzLyMjIy/igJ0gd2hlcmUgdGhlICMjIyBkb2VzIG5vdCBtYXRjaCB0aGUgaWQgZm9yIHRo ZSByb3cuICBBbHNvIG5vdGUgdGhhdCB0aGUgaWQgY291bGQgYmUgMSB0byBmaXZlIGRpZ2l0cy4g IEFsc28gdGhlcmUgY291bGQgYmUgZ29vZCBhbmQgYmFkIHN1YnN0cmluZ3MgaW4gdGhlIGNvbnRl bnQgZmllbGQuDQogICAgPiBFeGFtcGxlIHdoZXJlIGEgcm93IGlzIGZpbmU6DQogICAgPiBJZD0x MjMNCiAgICA+IENvbnRlbnQ94oCdYWJj4oCdDQogICAgPiBJZD0zNDUNCiAgICA+IENvbnRlbnQ9 4oCdYWJjIGZpbGVzLzM0NS8gYWJjIGZpbGVzLzM0NS/igJ0NCiAgICA+IEV4YW1wbGUgd2hlcmUg YSByb3dzIGFyZSBub3QgZ29vZDoNCiAgICA+IElkPTEyMw0KICAgID4gQ29udGVudD3igJ1hYmMg ZmlsZXMvNDU2L+KAnQ0KICAgID4gSWQ9MTIzDQogICAgPiBDb250ZW50PeKAnWFiYyBmaWxlcy8x MjMvIGFiYyBmaWxlcy80NTYv4oCdDQogICAgPiBDb3VsZCB5b3UgcGxlYXNlIGhlbHAgbWUgd2l0 aCB0aGUgcHJvcGVyIHdheSB0byB3cml0ZSB0aGlzIFNRTCBzdGF0ZW1lbnQ/DQogICAgPiBTZWxl Y3QgaWQgZnJvbSB0YWJsZUEgd2hlcmUgY29udGVudCBsaWtlIOKApg0KICAgIA0KICAgIFBlcnNv bmFsbHkgSSdkIHVzZSBhIHJlZ3VsYXIgZXhwcmVzc2lvbjoNCiAgICANCiAgICAuLi4gV0hFUkUg Y29udGVudCB+ICcvJyB8fCBpZCB8fCAnLyc7DQogICAgDQogICAgSXQgbm90IG9idmlvdXMgd2h5 IHlvdXIgZm91cnRoIGV4YW1wbGUgaXMgbm90IGdvb2QgLSB0aGUgcGF0dGVybiBhYm92ZQ0KICAg IHdpbGwgc2VlIGZpbGVzLzEyMy8gYW5kIGJlIGhhcHB5Lg0KICAgIA0KICAgIERhdmlkIEouDQog ICAgDQoNCg==