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 1osDdz-0008Rn-DM for pgsql-general@arkaria.postgresql.org; Tue, 08 Nov 2022 01:43:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1osDdx-0005IK-L6 for pgsql-general@arkaria.postgresql.org; Tue, 08 Nov 2022 01:43:13 +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 1osDdx-0005H0-8v for pgsql-general@lists.postgresql.org; Tue, 08 Nov 2022 01:43:13 +0000 Received: from mail-sy4aus01on2110.outbound.protection.outlook.com ([40.107.107.110] helo=AUS01-SY4-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1osDds-0002VE-H0 for pgsql-general@postgresql.org; Tue, 08 Nov 2022 01:43:12 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=RLPo177p1kNEOTwI4GWsd6fJC/LJXfd1fmmg6P9IYHpM2cd0SKHYTe2+k3e8Q742WVYOUOldJsHkB+X/QXPAeEl8OW6jbq6CHxMcPrJXwgBnIAhEqbKfiahx9KZX6oC8n36vSOC/13c1L5NLQJtfo9byKnHrzw/F7LcEUjtHzKANfkaWgLL+wH3k4aTnhSgeNtgqRObySY8ncnCPQreFQtk0ZR1Rx9sBMY7q58dHCabJLDChQzHkSc3n7+E5ZpsDqNazPHrCYvQ21L4HfNqSXfrqPGIizqaVC7YothHna9pZzs/SFf+ZQ357KMBdwmFRKfQ3Rua0UoTX8ynFmXln/A== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=B+a8ibkVImIXgjAwapv2YAYFbm+tDBqaZ+jTcJLGiAM=; b=NsZyZ24pMHMeLPUmKFNTBp8xc+DO9Z+BNrWCZ8QdNFiMsvaaPDPMzVMCWECaawda+zh+7m5rAD8/QhNqlSLzxpGExSmTZtHpQHGdN2kARxDLLSrrH9QHqXsO5K/bfMw9M2m4Fj3KJ9RxU3smlAfq/u4LXfRlx1alQa4KBQ+h9KejHn7Vk6dokYD6SogJvX14Z+3clpT04AoH4cmdilDNJYpgANIsWBCSbMPQ+X21qzGQ35B6CxjQHIC4kCyBn0dZRsaeOQDyI3dZE2ajInJSviZs6S+HN1kWGYVgM21I3F/2ATZrlZBoAVUeGLes/55IRkIFQMt78qd4xLdNw2mF0w== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=eftlab.com.au; dmarc=pass action=none header.from=eftlab.com.au; dkim=pass header.d=eftlab.com.au; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eftlab.onmicrosoft.com; s=selector2-eftlab-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=B+a8ibkVImIXgjAwapv2YAYFbm+tDBqaZ+jTcJLGiAM=; b=OC1qELATtYqGxLskZpoxBOqgf9Cp1SlDU8PWWGbj7w5rMFvGWPJFGp6BriX377fHb3NDHgvCLKMt0maO5l0KLTbIOmSne91Kp9osslHZLgkdLn1tpW76qGpHe9xQcQjOeokCvP/6BqpsFE9kiu9xi6qH/uZhQuv8JerRCygzleI= Received: from SY4P282MB3940.AUSP282.PROD.OUTLOOK.COM (2603:10c6:10:195::11) by SY6P282MB3832.AUSP282.PROD.OUTLOOK.COM (2603:10c6:10:1d3::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5791.27; Tue, 8 Nov 2022 01:43:02 +0000 Received: from SY4P282MB3940.AUSP282.PROD.OUTLOOK.COM ([fe80::3b12:1d60:628:5476]) by SY4P282MB3940.AUSP282.PROD.OUTLOOK.COM ([fe80::3b12:1d60:628:5476%5]) with mapi id 15.20.5791.026; Tue, 8 Nov 2022 01:43:02 +0000 From: Jan Bilek To: Christophe Pettus CC: "pgsql-general@postgresql.org" Subject: Re: PCI:SSF - Safe SQL Query & operators filter Thread-Topic: PCI:SSF - Safe SQL Query & operators filter Thread-Index: AQHY8xDl+kk6o73Esk2wlPMLLICB4K40PQcAgAADtwA= Date: Tue, 8 Nov 2022 01:43:02 +0000 Message-ID: <33a762ed-a045-c1e5-a042-cd4903f7de4b@eftlab.com.au> References: <23C450AB-9333-40CB-8ED1-F15D15BED878@thebuild.com> In-Reply-To: <23C450AB-9333-40CB-8ED1-F15D15BED878@thebuild.com> Accept-Language: en-AU, en-US Content-Language: en-AU X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.3.3 authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=eftlab.com.au; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: SY4P282MB3940:EE_|SY6P282MB3832:EE_ x-ms-office365-filtering-correlation-id: a6e55513-b1c7-4c27-46fd-08dac12a9304 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: DdZP5CmLGSQWuEX2/pi7/P9s4eyhbBG5LyB4mVyDdgXN/RYjp1wCrB/xLby6eGuJ1sPNvkjygfXYabYVKXOMTJ0iSLXF032Zv/LsMaXkguzAh7PnKsGMiiZq9nY7ZpgDSsEz0XtLFMqKgHqIoKwZ9P9JfS0RcfH07sfFrAZtDtOjoI4v5GxWMzb0ptYM7560ciYVOAVaFWMFMWHOs/IO/cK7R9Z7q07ZpnEw5fOuN5nJ2m2aHNAx6/NYHnWbVFhhKANd8bgRrxeBixz1uMssGBABSiOMok0z1tfnvf1fjMTdMG4UXY7ykEaSEI6WN2X3NIDb4OXd+ckEN6jRs8jz/E+0FFk0+vTebjtpXvqTn/VOe5IlS/kAqlgLKAEHPHOpPdYD0m9Gxq3eLv+3oFnzNRIIAexXH4pna7CfUt33BFFUllNQMBFkd3qAckaWM8RbPo2BxnfEhJd3vL3f5ZqxkU4Id4r3yrVv1p7Zh+2IvoHZ6di5KEFcZ/NbIqGSJJ7fqT53G9oDsmUu/uaGxJQyr92N4QtDAR1KOkmjG03qFaw1sTqLm+z6vGNMuDzrT9camvKeUPBTWYLxNBMbcA6mbRGXHygvwCRMFbFZaaEHNVF1uJQWASq6S1XlEPSlxgd4I0vBhKOXhQ5zD7co+pYkhtKJ6E/OTxl+ty74Y33i8gAg3MUsXpCCq83uyLeBnQ0lDLj5ydNzLnjgbSrVHpKjrH8kGolqE5/h+/iuCd//wDRtBnzocssXuuh98s7h8oXjp3g/vQRJuKJEc6FZ6cgen2AjQqpFJSEyPFSiCUoiGW9sVS/i+e24EUfGur8FxuFuAWp9CY7KNyqthkqY6gbqWg== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SY4P282MB3940.AUSP282.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230022)(376002)(396003)(346002)(39830400003)(136003)(366004)(451199015)(83380400001)(38070700005)(31696002)(86362001)(186003)(122000001)(38100700002)(41300700001)(44832011)(8936002)(2906002)(478600001)(5660300002)(6486002)(2616005)(53546011)(6506007)(66556008)(66476007)(76116006)(64756008)(6512007)(4326008)(66446008)(71200400001)(316002)(6916009)(66946007)(8676002)(31686004)(36756003)(43740500002)(45980500001);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?dmRaZXFkSDlrU29LZjVXTkN3eW1DS3lhTmFrbm9pd21HSlQ4dnpzVFEyV1RF?= =?utf-8?B?RzBHa2RxUC92NkhpanIwZzE0SUhOK0pidlZQNFBWbDlrdjFqdFBGNG9zLzJu?= =?utf-8?B?cWlieVJmTTVqZXRKQ1haaXZQOUxmcG1HYlZ2OWNjN0ZDYTBRZ2llNFpZZnpi?= =?utf-8?B?SGozdVFCbkJjQmZlVy9SeHpDK3Z5QlRUWXN2TVB1aDJZUXV0Z1A1MFF2RGxV?= =?utf-8?B?a3M0Z0N5Y2ZmZGlhTkVKRjJSeHRTaCtRMG5uZEpBdTd4K05kQ2xSOWtWT2tv?= =?utf-8?B?YVhMZmU2bWtjNHRhbkZ5R2RLdjFJNDVFNEJmNFVXRFlLRkZUOGN3czFmVnp5?= =?utf-8?B?SWw2NU9RRThJWjN3WjFjVEZWUXZBVUhSZFVlQU1VRlVEZm1WTENjRG9MUFBB?= =?utf-8?B?N2hzMDlXZnVEQ2JibFRSNWNRczhYR0RGdUdVZStqMVBNbTAwMEo2aTVBcFFu?= =?utf-8?B?eWUzYWcveUpEVlR6a1l6VWtXWUlTMW1BMTZlWnBrUHFyN2Z6UUV1STNORkNN?= =?utf-8?B?djZFanA5L0R0eEFPdEEvWjRyeGNTSW11ZklqVUJuMVFNWjY0SUMyYVdJdXhh?= =?utf-8?B?aUR2OERQRDRKY010RnBNK041NVkyUTVWRVlHU2hVWU5kcGJrQm9zYnV1ZnJ0?= =?utf-8?B?QnlmS2ZhVXNvWGVBZUFheWQ0U2MvTjlCTHRyK1IwMDYvWUc3bEpSK3MzNHRV?= =?utf-8?B?dFZpSTBGSC84QzJ0bFJaVU5OQVJlTzBRRGhmUXBzOWV2YkpTelBEMVQ3T21J?= =?utf-8?B?MVdjbk1yRC94VlYzd213dFRrUXFmSm5GUXhkOUNPQXZOSlhXeGhYTmIxdlIr?= =?utf-8?B?MjBrazhGYUkweHBUTnMrQ2lOcXlTRlFvanpURUVibVVwaEd3Sy8ybm0rTUx4?= =?utf-8?B?TzY4U2hMQXdERmQxaCtHQ2ZxRWtWd05VOE0rTUplazJrZzRoc3QxTFdUdW55?= =?utf-8?B?MWxHUm9oUkJpZkYrbmNFejIzdFVvQmRReHl2bVZOWnkzeXpQNjBTMHZaTDVY?= =?utf-8?B?ODlWOTNDdHJMR244Q3ZqME8rb05SMit4NW5TTDJnOUxqZFkzenZxTWxlQ2tk?= =?utf-8?B?emdPd1BZSlcxSjZaNnVEbHQwZ2V1RFFsN0lXZWJxNUpMclVzbWRkaEJGZzI0?= =?utf-8?B?RXlGN1dJUEUzSk8waDlWNWNXWUJ4VDNMMTRSZ2htcVk5TnBUTUVLRnJpUFBQ?= =?utf-8?B?Qkp0bzRtSHU4cDBBVE8yVXFCNURWZHRJSkIvSXp5eWdGS0VtKzlQQ3RCYTRU?= =?utf-8?B?Rys2bVplNGV6SmZHOFRZcXlETjVyMXFtdExaV1Q4aHZHNUh4TEZZbmJMOUxq?= =?utf-8?B?Zktibm9FWFJUV09qKzE3ZFJBaDBDYW9OeVpERDdPS2FlOWcyRVJjR0I0NWht?= =?utf-8?B?TWI5c1M0Q1k1ZEFjT0JEVFgveXE3U2IvY2JocXFoT2JXbWZROHpybmxJSGo3?= =?utf-8?B?TG5xK1Qra3k5eUxFUGZ1dkFUOTEwUWg4NFpjM0tjblpOZWg3MWc1anRKbExF?= =?utf-8?B?NGRodXV4bUpoQnl2d2NET1laMkFaK1UzTjNHRVRtWGdUWGdPaU85K0lUWEZl?= =?utf-8?B?SjhkYXg2YUF3NWtrbExTWVUveTgrQXFuWVB0OU5zZzhHS2F6Z0VTc3A0TDRz?= =?utf-8?B?aE8zOEtORHozcXBrTldpN3VZL0svRUthTW4wTWRxcmU4WWQxUGdQOEFuUW9l?= =?utf-8?B?QlZXaHZmVHBWcmF1Z0xrWWpTcWJXQTcyYXhvV0c2ZU5IMUovNE9GcFBRWFBZ?= =?utf-8?B?cFJjUlRkblhnVTkySmFNbk50STRPSlgrRVBqYmZjZlJJaG9GRWgzekxnc0M3?= =?utf-8?B?S3RaamdjaWtQd3lsYk95bWVZNkcrMzdWb3pmMDYyZkVuRWhqelMxNmI2M3Rv?= =?utf-8?B?TVNYdWVpR3FwY1lGNUNxY1VwS29Cb0JIaEFtYXg4Q1d6cUFhZWsva1NEVjBT?= =?utf-8?B?QzN1bGU2bE43UHkwdC9wVG1ZR203cHFXSWoxSnFvK1F5cm0zS3NGaERqR0Yv?= =?utf-8?B?dVVZb3Iyclk1R1gyVFFPWFZEbDdFWmFGTmdwaWVsUjFGMng2M3h6eDN2WmVP?= =?utf-8?B?UVkxaERmejRIU0xzekFuSEtFWmIrc1VRb3hnYkZHZXRnYkd5bVJ5cDdrdHZG?= =?utf-8?B?OGVhd3J2ckQ5QjhZbkJUVDViNm9zeXhxR3RxYVZRL0tZRENpQllYWXRuK2Rv?= =?utf-8?Q?Y75h1bSd/XafONGsvZKkRiQCJsNaQHCj1Yf+e+vj0tYX?= Content-Type: text/plain; charset="utf-8" Content-ID: <7D8DD9C4265243488A2FA5F68490EE26@AUSP282.PROD.OUTLOOK.COM> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: eftlab.com.au X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SY4P282MB3940.AUSP282.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: a6e55513-b1c7-4c27-46fd-08dac12a9304 X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Nov 2022 01:43:02.5352 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 67fe4223-4b63-42ad-8611-d96b12e52060 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: +70FfLh9E9it3Yry2iK8BF7jLVSo0YRw6FSSR+gjTUVktVAV/GUOOPraSRdNrartfXPEue0JbeCGcfU0r1RItw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: SY6P282MB3832 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMTEvOC8yMiAxMToyOSwgQ2hyaXN0b3BoZSBQZXR0dXMgd3JvdGU6DQo+DQo+PiBPbiBOb3Yg NywgMjAyMiwgYXQgMTc6MjQsIEphbiBCaWxlayA8amFuLmJpbGVrQGVmdGxhYi5jb20uYXU+IHdy b3RlOg0KPj4gV291bGQgdGhlcmUgYmUgYW55IHdheSB0byBnbyBhcm91bmQgdGhpcz8NCj4gVGhl IHR5cGljYWwgY29uZmlndXJhdGlvbiBpcyB0byBub3QgcGVybWl0IHRoZSBQb3N0Z3JlU1FMIHN1 cGVydXNlciB0byBsb2cgaW4gcmVtb3RlbHkuICBUaGUgZGF0YWJhc2UgY2FuIGJlIG1hbmFnZWQg YnkgYSBkaWZmZXJlbnQsIG5vbi1zdXBlcnVzZXIgcm9sZSwgaW5jbHVkaW5nIHNjaGVtYSBtaWdy YXRpb25zLg0KV2VsbCwgc3VwZXJ1c2VyIChvdXIgQXBwKSBpcyBhbHJlYWR5IGxvZ2dlZCBpbiBh bmQgYXMgaXQgaXMgZGVzaWduZWQgDQp2ZXJ5IG11Y2ggYXMgYW4gImFwcGxpYW5jZSIgaXQgc2lt cGx5IGRvZXMgdGhhdCBqb2IgLSBtYW5hZ2VzIGl0cyANCmRhdGFiYXNlLiBUaGVyZSBtaWdodCBi ZSBhIHdheSB0byBleHBsb3JlIHdoZXRoZXIgd2UgY2FuIHVzZSBpbnRlcm5hbGx5IA0KYW5vdGhl ciAobGltaXRlZCkgdXNlciBqdXN0IGZvciByZXBvcnRpbmcgcXVlcmllcyBvbiBhIGRpZmZlcmVu dCANCmNvbm5lY3Rpb24gc2Vzc2lvbi4gQnV0IEkgYW0gZ2V0dGluZyAoc2VjdXJpdHkgcmVsYXRl ZCkgaGVhZGFjaGVzIGp1c3QgDQp0aGlua2luZyBhYm91dCBpdC4NCj4NCj4+IENSRUFURSBPUiBS RVBMQUNFIExBTkdVQUdFIHBscHl0aG9uM3U7DQo+PiBISU5UOiAgTXVzdCBiZSBzdXBlcnVzZXIg dG8gY3JlYXRlIHRoaXMgZXh0ZW5zaW9uLg0KPiBUaGUgcmVhc29uIG9ubHkgYSBzdXBlcnVzZXIg Y2FuIGNyZWF0ZSB0aGlzIGV4dGVuc2lvbiBpcyB0aGUgInUiIGF0IHRoZSBlbmQgb2YgdGhlIG5h bWU6IEl0IGlzIGFuIHVudHJ1c3RlZCBQTCB0aGF0IGNhbiBieXBhc3MgUG9zdGdyZVNRTCdzIHJv bGUgc3lzdGVtLiAgSWYgYW55b25lIGNvdWxkIGNyZWF0ZSBmdW5jdGlvbnMgaW4gaXQsIGFueW9u ZSBjb3VsZCBieXBhc3Mgcm9sZXMuDQoNClllcywgYWdyZWVkLiBBbnkgaWRlYXM/DQoNCi0tIA0K SmFuIEJpbGVrIC0gQ1RPIGF0IEVGVGxhYiBQdHkgTHRkLg0KDQo=