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 1gLB4D-0002lc-SL for pgsql-sql@arkaria.postgresql.org; Fri, 09 Nov 2018 17:59:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gLB4C-0005TH-9H for pgsql-sql@arkaria.postgresql.org; Fri, 09 Nov 2018 17:59:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gLB4B-0005T9-VA for pgsql-sql@lists.postgresql.org; Fri, 09 Nov 2018 17:59:36 +0000 Received: from relays-agent08.techservices.illinois.edu ([204.93.2.8] helo=illinois.edu) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gLB46-0005Dl-N4 for pgsql-sql@postgresql.org; Fri, 09 Nov 2018 17:59:33 +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=MVBnsV0cEnBxyei8hSZ6cKlZkcSH7Z1zImmyK2YJ87M=; b=GbiGQBxYKyGl8qsAytczjRRyMzH0YNH1ddHn71ekGMKjB0dWfCRvD6mgyPSzXkkUdQe3 2FhTuM73Hnar9/lZ0+qx/jqcyLCvOWfrFGrQvbdMztbz6Vi+lilAYHo/HPEhuaMwiH0q +Y5eEU2hHNdefMc8DWG7/InP53b4YaUvA4ys2aAZjKmqffImCIwIVLZdL8rVw7+Rd6C9 5w+WKDUxN8OBKnriLSUCsLe8Za5dXFdel7UhFNt9A6Cn76/197ZqU0EY4MbMDUCjDg1M xruunuOnOmnM9NJDBEIle2xRCkLH+pAnocRcirWdNMjdixCIHIwca36VdH0Qfr37/RtW cQ== Received: from NAM01-SN1-obe.outbound.protection.outlook.com (mail-sn1nam01lp0114.outbound.protection.outlook.com [207.46.163.114]) by relays-agent08.techservices.illinois.edu (8.16.0.22/8.16.0.22) with ESMTPS id wA9HxKnX000375 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Fri, 9 Nov 2018 11:59:22 -0600 Received: from DM5PR11MB1484.namprd11.prod.outlook.com (10.172.36.143) by DM5PR11MB1580.namprd11.prod.outlook.com (10.172.37.141) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.1294.28; Fri, 9 Nov 2018 17:59:10 +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:59: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//+fQYCAAGikAP//pZyA Date: Fri, 9 Nov 2018 17:59:07 +0000 Message-ID: References: <47589FBF-7910-4F95-8239-BDF702A19B2C@illinois.edu> 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;DM5PR11MB1580;6:HF9FCdUq0pbIdvQsLYqeu7QrprsVZu5cSH893GnM/ULhkiTWk8dF7lV2pPH/oZRqW/anllMs3TJchbrfN/klKZIIgHVRRLXEJs/6VuvCSF1W41wDshuxdgKjTiftjPLFTMTvfbB6cEi5ERENMg6KwEzQxVpwpg68XZuNhpVj5/DuFJ/Z+aYNZjySfWSBA8WMZmykkS/OF5u42oH4h8gJTX7c3GKi1rgT8N0zIp808nJlhsGrr0kEBALCSYFHewl1ETCJmZ3hbgq8/cl4Ix82YqfUy+ZNyb2SiDCfiE6oRUhmjEk/hOCOsE+ms2B0kqPpDJn1sfxH/JlnNAEgiBzu7yq0fmP5tFDP8KOxGz7gVpLhc0WrZHX+z/klpGwohF1j1Zhj9585tzC3tmV1u/zJgSeuW0vgufo/dnZKoq4O16hsVzb118ktx1mqOxZAQLWqFJnQ7R+P9QxfGI4709/t6A==;5:vsyJY8u4gbCOGiygKsBr7R5S2R8fKE0GE0UxslrjoBohC4+j7FMJUZKDMgQI3A/8r2YjHtQhPyQf5ETeHkczDNPfgjC/fciWCbPvnq0cNGRbyMkEKonAjOsU06puLoZJKHFn/n/4ymz1bgvI7iPNWNqXacXdeRfFmtfwbztl4RU=;7:UxvO0FOeOGCckWDDjIDx2g1dtNZIvxAhxCOdN1uF7UBC45lxCWk/OTY4/aQBvWIAa6HoX4mWw5BsjH7HLAufwnOG5PWBh6pA3vx78LiB08KAEKhGJAb4Oy/IF8uLB1UpVbHW0eKpKWc5Kj+nHAb2GQ== x-ms-exchange-antispam-srfa-diagnostics: SOS; x-ms-office365-filtering-correlation-id: 509ebd0c-e320-4945-4fd6-08d6466d0bad x-microsoft-antispam: BCL:0;PCL:0;RULEID:(7020095)(4652040)(8989299)(4534185)(4627221)(201703031133081)(201702281549075)(8990200)(5600074)(711020)(2017052603328)(7153060)(7193020);SRVR:DM5PR11MB1580; x-ms-traffictypediagnostic: DM5PR11MB1580: 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)(3231382)(944501410)(52105095)(3002001)(10201501046)(93006095)(93001095)(148016)(149066)(150057)(6041310)(201703131423095)(201702281529075)(201702281528075)(20161123555045)(201703061421075)(201703061406153)(20161123558120)(20161123564045)(20161123562045)(20161123560045)(201708071742011)(7699051)(76991095);SRVR:DM5PR11MB1580;BCL:0;PCL:0;RULEID:;SRVR:DM5PR11MB1580; x-forefront-prvs: 08512C5403 x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(346002)(39860400002)(136003)(376002)(396003)(366004)(199004)(189003)(186003)(102836004)(14454004)(5660300001)(6246003)(71200400001)(71190400001)(11346002)(2616005)(39060400002)(476003)(93886005)(88552002)(25786009)(33656002)(2900100001)(83716004)(446003)(4326008)(53546011)(486006)(66066001)(256004)(14444005)(305945005)(97736004)(6506007)(7736002)(26005)(229853002)(6436002)(6512007)(6486002)(86362001)(76176011)(82746002)(105586002)(99286004)(81156014)(8936002)(8676002)(68736007)(6116002)(3846002)(53936002)(58126008)(786003)(36756003)(2906002)(81166006)(478600001)(6916009)(316002)(75432002)(106356001);DIR:OUT;SFP:1101;SCL:1;SRVR:DM5PR11MB1580;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: G8BdmyuiQUR3JAXA2A5R7yOqG89JYZxAPA9sYHjIom+ns6vAN4W+LAS+g5IXyxWt0biXikVEJ45YYZjFjEzS1hbOODGDYZkC2c8XYuBMtfPGCoqAlXQ9VjTvcOdMY7oKDM/Gm1B4IKLJchnnzZ+RLy7YX4kxHGUDl1ZmlURyD1PL/VCCo9SpZrbMnl4r1XKLeJn27zr3b90QF5baYtHw8quGP3ZRFjgG9ybV4lPbUtSCClePOsarK7frPYXVJJmBJuLou3/wSiSxj2Wow6P+8OhuhsnmZG6p7v+IvFrYo4kZmkFCJ0EXiYWFncTTTHNMBJL/P10iEMZrqW1cl32lZgsoXgIE62JgE8XM9JJzvrA= 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: 509ebd0c-e320-4945-4fd6-08d6466d0bad X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Nov 2018 17:59:07.9459 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 44467e6f-462c-4ea2-823f-7800de5434e3 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM5PR11MB1580 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=1015 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-1811090164 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 VmVyeSBoZWxwZnVsLiAgSSBhbSBhbG1vc3QgdGhlcmUuICANCg0KSSBjcmVhdGVkIHRoaXMgU1FM Og0KDQpTRUxFQ1QgcmVnZXhwX21hdGNoZXMoY29udGVudCwgJy8oPyFmaWxlcy8nfHxpZHx8Jy8p KGZpbGVzL1xkKy8pLycsICdnJykgRlJPTSB0YWJsZWENCg0KSSBnZXQgbm8gbWF0Y2hlcy4gIE15 IGd1ZXNzIGlzIEkgYW0gY2xvc2UgYnV0IHNsaWdodGx5IG9mZiBvbiB0aGUgc3ludGF4Lg0KDQpM YW5jZQ0KDQrvu79PbiAxMS85LzE4LCAxMToyMiBBTSwgIkRhdmlkIEcuIEpvaG5zdG9uIiA8ZGF2 aWQuZy5qb2huc3RvbkBnbWFpbC5jb20+IHdyb3RlOg0KDQogICAgVGhlIGNvbnZlbnRpb24gb24g dGhlc2UgbGlzdHMgaXMgdG8gYm90dG9tLXBvc3QgYW5kIHRyaW0gdW5uZWNlc3NhcnkgY29udGV4 dC4NCiAgICANCiAgICBPbiBGcmksIE5vdiA5LCAyMDE4IGF0IDEwOjA4IEFNIENhbXBiZWxsLCBM YW5jZSA8bGFuY2VAaWxsaW5vaXMuZWR1PiB3cm90ZToNCiAgICA+IFRoZSBTUUwgeW91IHByb3Zp ZGVkIGlzIHRoZSBvcHBvc2l0ZSBvZiB3aGF0IEkgd2FzIGxvb2tpbmcgZm9yLiAgVGhhbmtzIHRo b3VnaC4NCiAgICANCiAgICBTZWUgaWYgdGhlc2UgaGVscCB5b3U6DQogICAgDQogICAgU0VMRUNU ICogRlJPTSByZWdleHBfbWF0Y2hlcygnLzEyMy8gLzQ1Ni8nLCAnLyg/ITEyMykoXGQrKS8nLCAn ZycpOw0KICAgIFNFTEVDVCAqIEZST00gcmVnZXhwX21hdGNoZXMoJy8xMjMvJywgJy8oPyExMjMp KFxkKykvJywgJ2cnKTsNCiAgICBTRUxFQ1QgKiBGUk9NIHJlZ2V4cF9tYXRjaGVzKCcvNDU2Lycs ICcvKD8hMTIzKShcZCspLycsICdnJyk7DQogICAgDQogICAgWW91ciBtYWluIHByb2JsZW0gaXMg dGhlIHNjZW5hcmlvIHdoZXJlIHRoZSBkZXNpcmVkIHN0cmluZyBkb2VzIGV4aXN0DQogICAgYnV0 IHRoZW4gb3RoZXJzIHRoYXQgYXJlIHVuZXhwZWN0ZWQgZXhpc3QgYXMgd2VsbC4gIFdpdGhvdXQg dGhhdCBpdHMNCiAgICBhcyBzaW1wbGUgYXMgbG9jYXRpbmcgb25lcyB3aXRoIHRoZSBjb3JyZWN0 IHN0cmluZyBhbmQgdGhlbiBuZWdhdGluZw0KICAgIHRoZSByZXN1bHQuICBZb3UgbWF5IGZpbmQg eW91IHdhbnQgdG8gdXNlIG11bHRpcGxlIHRlc3RzIGFuZCBjb21iaW5lDQogICAgdGhlbSB3aXRo IEFORC9PUi4NCiAgICANCiAgICBEYXZpZCBKLg0KICAgIA0KDQo=