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 1kZwZe-0007fF-3N for pgsql-bugs@arkaria.postgresql.org; Tue, 03 Nov 2020 13:42:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kZwZ7-0007XA-HG for pgsql-bugs@arkaria.postgresql.org; Tue, 03 Nov 2020 13:41:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kZwZ7-0007X3-2k for pgsql-bugs@lists.postgresql.org; Tue, 03 Nov 2020 13:41:37 +0000 Received: from ore.jhcloos.com ([192.40.56.151]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kZwZ4-0007GP-0t for pgsql-bugs@lists.postgresql.org; Tue, 03 Nov 2020 13:41:36 +0000 Received: by ore.jhcloos.com (Postfix, from userid 10) id BC0CC1ED05; Tue, 3 Nov 2020 13:41:29 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jhcloos.com; s=ore17; t=1604410889; bh=3D7i/WZvND2A99wVwc6BaV0p6nY91Q5pNT0Qe98gq7Q=; h=From:To:Subject:Date:From; b=BHoLDQfjWAvdXZ9BOdyiXTde4E8arpsPMpYYzPKv0cFqMq//eQbrFhLeNsMeRgb5d XTj3Zy3gGCSj2XVOAup2bLvHgZznMD33/zaa8fatnfTi/sqcwUSWHeNuwVAf62mJoq KMht1h2sxk0WFP2D1Vl5zXOcxlIRb0Tzg0ZdhtOjCfFuobMI7kI2J69Mysq9OFnGpf wiuG+oajSwrltX1jmi2BftVZj7GWhLJJI9XOOpMEYjlKP7wI18lYdxTP5dEkmV9awS LMK/OYB9MLTOEvXc0uGuV7n63l5SAzg0sjgNzUCtZvg3n/SuzYzwTCTbdAypvW2qC/ t3FVYZYxVyq7g== Received: by carbon.jhcloos.org (Postfix, from userid 500) id 3604F5C8B5; Tue, 3 Nov 2020 13:41:23 +0000 (UTC) From: James Cloos To: pgsql-bugs@lists.postgresql.org Subject: pg should ignore u+200b zero width space User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) Face: iVBORw0KGgoAAAANSUhEUgAAABAAAAAQAgMAAABinRfyAAAACVBMVEX///8ZGXBQKKnCrDQ3 AAAAJElEQVQImWNgQAAXzwQg4SKASgAlXIEEiwsSIYBEcLaAtMEAADJnB+kKcKioAAAAAElFTkSu QmCC Copyright: Copyright 2020 James Cloos OpenPGP: 0x997A9F17ED7DAEA6; url=https://jhcloos.com/public_key/0x997A9F17ED7DAEA6.asc OpenPGP-Fingerprint: E9E9 F828 61A4 6EA9 0F2B 63E7 997A 9F17 ED7D AEA6 Date: Tue, 03 Nov 2020 08:41:23 -0500 Message-ID: Lines: 21 MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk i had a hell of a night last night trying to figure out what was wrong with an attempt to use on constraint. this morning i tried again and it worked. but pasting the failed line from .psql_history into psql still failed. i had to resort to od(1) to discover a no break space showed up just before on constraint in the failing lines. pg should treat a no break space after whitespace as just more whitespace. i'm not sure about alone between printing characters, but definitely immediately after current whitespace characters. [sent directly to the list because the 'community login' form is b0rked.] -JimC -- James Cloos OpenPGP: 0x997A9F17ED7DAEA6