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 1osG0N-0007xR-Fd for pgsql-general@arkaria.postgresql.org; Tue, 08 Nov 2022 04:14:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1osG0L-0005EA-UJ for pgsql-general@arkaria.postgresql.org; Tue, 08 Nov 2022 04:14:29 +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 1osG0L-0005Dt-Cs for pgsql-general@lists.postgresql.org; Tue, 08 Nov 2022 04:14:29 +0000 Received: from mail-me3aus01on2127.outbound.protection.outlook.com ([40.107.108.127] helo=AUS01-ME3-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 1osG0J-0003sB-4q for pgsql-general@postgresql.org; Tue, 08 Nov 2022 04:14:28 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=PP1WZV5k0TRwUiQ+9vVZvP9H42MnwCKjldX9BnCASO5EQMJBlK514ijVD6UBmFKmtf19sNQadjhvpHNDvrVkDOh2Qsw4SN3yZ3O3Q/wtTIvzrsR/V+DtszfD/ocvkHh43SqbJ/RiDOY6YqAVr9RpTUVk9rzAdz6H2a7eH6lAqUKdoQcM+Mc6sHnZ9bpLhc/CxtVK105ZvUFKfPzW5KGSYbelKzdw6CrOTi/Tj7Pps5uA8v/AezuR6epMHcAykJWwjNV1oUErIFK5Hmaf8E/UtwFqsNESq14C4Zrlb0KH0XRCfQcPv7VGdanRwZfxRymBE6xGM6Gi6GAoTE3D5ZCSSQ== 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=dMYzCLLC9oTMREOpMsnuJf3YsSvtDArhj3QTqbtRxlw=; b=dkq4VHG61o9gUbFnGMAiMMPh8sen50Y91fWrYV5UCr9iU7DoGNVnwIU967V4pCFGeIMDpdLLJngT691eh1iWXEFLYJtlpEZuDfVXbURRG/2hy8HR7pcq8geUGFW02iUQBqiIPiHkgonAsIhPfHjm8fKOqTojY4EGdSRGFnQ5MQp+APN+rwVO1FSV3U15j++XKNamWljm7wAHL8PInpIxjN/Ab106VFUUdJkM6jSIrS2tctDPAcxyja1XqM4O/nOXceJgjHkrcS4BnGbbZH8KqCbjXZTr3kICbRGeKTEmV7Cb1KNBiWRRmYSvNC5Bqy77TDW7qBRrQWnERcKC5pUWJA== 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=dMYzCLLC9oTMREOpMsnuJf3YsSvtDArhj3QTqbtRxlw=; b=qO2CXdMIKi6CxiAq00h3DH0jrvhHPcSKFw7biPTKdboDXywn5o4fKzynjhR/CSJqf/8szUQ7WsVEdWePMDKO6gMIfiE868h+jN5powiQwHmTkYRHbjx//x/bk7THW3y0wwV4nwfplyWfp1cfF0JbGIBjxNW87vDlXyjBBfid2B0= Received: from SY4P282MB3940.AUSP282.PROD.OUTLOOK.COM (2603:10c6:10:195::11) by SY4P282MB3519.AUSP282.PROD.OUTLOOK.COM (2603:10c6:10:1b6::9) 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 04:14:20 +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 04:14:20 +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+kk6o73Esk2wlPMLLICB4K40PQcAgAADtwCAAAIBAIAAKESA Date: Tue, 8 Nov 2022 04:14:20 +0000 Message-ID: References: <23C450AB-9333-40CB-8ED1-F15D15BED878@thebuild.com> <33a762ed-a045-c1e5-a042-cd4903f7de4b@eftlab.com.au> <87E0DAE2-248C-4F47-B333-436D515FD36D@thebuild.com> In-Reply-To: <87E0DAE2-248C-4F47-B333-436D515FD36D@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_|SY4P282MB3519:EE_ x-ms-office365-filtering-correlation-id: 3ead9898-e4c0-4f8e-8726-08dac13fb5bc x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 5gWVa0k5Ur5rmI9yuwghjl70V8OiS52eAiDqnGxwbeej6k7b46EeYjBnNF3RsYKFVuStUYtOIBUlMK9HNcj8tI2ucAGTIhVYZCKZTWGSTiji1BrmiUGtNiHVCCeBxFWUd/bvj/EGe4QuNrEzFXs720OVC2QmedXqnyaX8gCTUCROSkvuObtN1cTn7R+4QtXs9eWCp2kGGSosIjNNMjrrIQOcn4RibylZU3MxoEbCA6hp46Zca0+OBE1UVKiJQnoGTpXjvmx6LQBAfJ9gNL75jGu+ESEh+VnKSpTpLAOcAQ5F7j/KOL3Ob8IofXcxvnioGtOAMcqVcekbXwDUauvVo217i/ZYw6xzmnb1qNqiuHGJk+5L9uguDgtriWL35Ek0uyxe2yZOM7l/BzYPvW6bNqBZr4kIxi6bJogo0pe3Tb7lxTvS3Yqkal/ZXLCIiMn9JoYk//7JVo51luDhmqkU2f+Wy8md8D/7b0JwpF4zljAj8Zlt20q7FKphSJPjwNIXQorH7HEMYerQBwB7Q7u/+ABR/PKmdcMkWWnpfeINK7kgkIgz6O/6JN5Ywp/OyoPocjgIOz3kijhyaVUJpll7oc9HYr/zSDismrpZV/wxos42RhEHAUOKexOkgmjqSKgl3XmPp9Ght9nsAMFIS0CWwjkAOfi1mqVe30fkZG+KYiCrreVoSqdQsFGwvLc057yT8Sw8PCmFd3pPzgMufuKYaHVs290gtWzszbWtf/c4qXJXf9gFMGWjxVV+qpHV3j+gIQ7WIbDMw9Iz4oUPQKhj7O2heLO5LxlrUmEqYBoVU7ZshoSRG7Q3YRYyGCkqMXhRCFh7O9jVoljphm5z/WxbWQ== 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)(39830400003)(396003)(136003)(346002)(376002)(366004)(451199015)(36756003)(186003)(83380400001)(38100700002)(122000001)(2616005)(86362001)(66446008)(5660300002)(41300700001)(8936002)(8676002)(4326008)(31696002)(44832011)(2906002)(6512007)(64756008)(478600001)(31686004)(6486002)(316002)(6916009)(71200400001)(6506007)(53546011)(38070700005)(66476007)(76116006)(66946007)(66556008)(45980500001)(43740500002);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?bkozRzJCSDNXc2RTbkFuQ1J1clh1YlI2N0dmbEpPY3pzb21OVlRJcXUxUXpM?= =?utf-8?B?ckFuUDljMVoyeGpJSEVwQ3VHcXdVWXQ1RThRdlExWk8xaEZoMXpUTFpDUGNU?= =?utf-8?B?ZU13RU1ENzdiejlLSGFjRjFyRG9iWVdzQXVjbnlUbzE2Y25tRmZnTnNucHlm?= =?utf-8?B?VFhrTk85TDVMeTlLbEdGd25ZYkZ3SEV5TXh0WGNOWnZQRWhCQW5KSytCMUVU?= =?utf-8?B?TkJxT3Npb2RNVGJYRWhoVkFaczZHd1dLUVpkc2Vta1VmbW5PRjhmWHpuNk5r?= =?utf-8?B?Ky9iM2p1RmdYdmZQM2wrWnE1SzY5RnlxS1k0dzU1cTVIallVZENBdVdoYWFw?= =?utf-8?B?RXB5SFFRSmI0THMxZkl1N2ZzWkE5THNzeVNzRno1MHZoSm5PdVZ1c2IzcmNv?= =?utf-8?B?dGZ6c05rdHVUZDNqVTd3aStkcFcrbUFUME9DdG9FenpDcU5YK2pWU2Q1ei9D?= =?utf-8?B?c2R3K0dSUDBSM2EwdWtheUhCNk5NN1lWbkxxNksrajBkWjdDNUVoQ0taYzJv?= =?utf-8?B?VHpZSkR0MEp4TU1jY3FDVytoeU4zTkV1TFp0NVdqTkJKbmZWUnlxenpSUzVz?= =?utf-8?B?eG1BSDQ3UGp5NmsxMHQ2V3BtSUNrSWVBL1lUWHI4d21jUWE4OGovMk5mcVZR?= =?utf-8?B?UHR6NFZxb0Q4R2xEQXRhY0pFbnhSeTcvL3NVKzF0U0dIcFk0ZHlPUUxBZWhR?= =?utf-8?B?bWFpZFgyYTYzRlZkK3dZdnZ1UG84ZjhoRlFsdTlkWXNKRUYzVGZyWDBPSDVa?= =?utf-8?B?czQzazhvOENRNWhqUHo4SEt4SkZUUTFxOTFUUm8reG96YjJ5Y0xlMG5WQXdZ?= =?utf-8?B?dThZL0k1QjFEV1pPWnAxaGhUUm13dkdWaWxNaTVkSnczVzQvVUJqbm13M3RL?= =?utf-8?B?VDkyek00WlFaMVhXcUE5Y2pOZnJMQmI4TkxoclZFQTV6ZnJNdThFUVdsZWF5?= =?utf-8?B?WEluYzBjdWRUVWVJOG5VT3BXajJGT3JoK2ZFeCsyYUJsbDd4eisySmRHR1lT?= =?utf-8?B?UEljcUxBcER1N0dnbXV0bTBHQ3JtbzFOTnEraSs3cW9YRFB6blpLcm1aUW5h?= =?utf-8?B?Yy9NZnR0eityZ0VxUWRhaDZZS016b05na2pkRERVTGVlK3d0anN3VFVoalc3?= =?utf-8?B?MUp2MU9uazNuQTFQdlc0UkY4RjhnVzlUTVlpTEFlTXc5b2lnUk5YaHhmb1A4?= =?utf-8?B?czBGSHdrNHZVQ3ViMjAyZ0Uwa1BBb2hBWW1UcFRzRzFDZjlvc29Fd2VYZ1lT?= =?utf-8?B?RVlYRi9QcVc0VFl3Wk5JSE9iY0Izd0Z4VW1WZ3MwWVM1YkpBNEYwRFBwUFhn?= =?utf-8?B?cUNYWGFEaGhkUStLV3MvVTNhOGFIOFhsU2dOaURuYVBWZkp4dkF5T1Z6OEkw?= =?utf-8?B?Z3JSQ2FqMTIxazFHdWxQNEozZlFwL3Y4cDVlYmppUHZ5YUgzM0ZUWFVwOS9v?= =?utf-8?B?Z3VZcmsrM3k2a1JFZTMrU1A1aWQ1ODN5ZzJOem9zYU9PeFNVYXJiaFh3Snp1?= =?utf-8?B?NmpaSk54dW1TbzhXNFdzTHlLWWUvazdub2tGTElJVzB1bWtsSUFxaFJnRFU2?= =?utf-8?B?cVFVVStVWEtjY3RQQlJjckZTdi82NFFQTFVGMWlpWnVlaFdqMFd0aXNsVlRk?= =?utf-8?B?c2l6MGpzQmJpdHZza0Z4TmpkOSt6aVZrQU1oU0x6UmIzQVFVSkl0QjlrVVUy?= =?utf-8?B?YzRIcUloV0VyZ1BpRVZCZlNTRVVZdEtxbnowVHhQRDJjaVl2TS9BSmEzVjRI?= =?utf-8?B?YUdPUXVUWjROaGRBYVZSbUs0LzRDUzBHYU5ONXZUK2RRM3RFWGd0NWNlYUpx?= =?utf-8?B?WVRzQmlxMk9rNXBQL0U4WWttK2pHQ0gvaWh0YWVjTHorS3hEc2d2UjVqWElq?= =?utf-8?B?dVdyVExCdHBPNnVxY1RYRWdBaS9QK0Z2OWQzKzY2WW5OR2J6UDZSSmk5aFRl?= =?utf-8?B?MjgvQnZDTUQxbW1ESDFiTnRleWE1aHM4a1JxM0E1K1dxUmRkeHYzT2tZdXRo?= =?utf-8?B?TUZpeXdWdnJ4MWdvU2tDVDdaNm0ya0RDbE9YSEMvRm5GK1JIT08vS0hqZVJ0?= =?utf-8?B?WlVpU1FydWRXYmFCS2lJM0p6Zks3ZWJkWnl2YzkyMFZwRzZxSFFKMVhTdE91?= =?utf-8?B?MitSd2xMaTN2YlVHLzhMUEtBRHFueVhvTWk1M04rWHNWaHQ0TEdBU3FzNFBo?= =?utf-8?Q?4Y51Ir4IQY7JU7Z1FRZYIQnjoFKo4fYP6uFliF7J+vKw?= Content-Type: text/plain; charset="utf-8" Content-ID: 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: 3ead9898-e4c0-4f8e-8726-08dac13fb5bc X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Nov 2022 04:14:20.1853 (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: MJhzR4YDKnf1ftMJ54PcD/Aaq5KQZsZO0wPmMs9lUXd81NqQX39SR044bb/a4sO4IOrVWmDMPGkQRyZg4TbZ3A== X-MS-Exchange-Transport-CrossTenantHeadersStamped: SY4P282MB3519 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMTEvOC8yMiAxMTo1MCwgQ2hyaXN0b3BoZSBQZXR0dXMgd3JvdGU6DQo+DQo+PiBPbiBOb3Yg NywgMjAyMiwgYXQgMTc6NDMsIEphbiBCaWxlayA8amFuLmJpbGVrQGVmdGxhYi5jb20uYXU+IHdy b3RlOg0KPj4NCj4+IFdlbGwsIHN1cGVydXNlciAob3VyIEFwcCkgaXMgYWxyZWFkeSBsb2dnZWQg aW4gYW5kIGFzIGl0IGlzIGRlc2lnbmVkDQo+PiB2ZXJ5IG11Y2ggYXMgYW4gImFwcGxpYW5jZSIg aXQgc2ltcGx5IGRvZXMgdGhhdCBqb2IgLSBtYW5hZ2VzIGl0cw0KPj4gZGF0YWJhc2UuDQo+IFdl bGwuLi4gZG9uJ3QgZG8gdGhhdC4gOikgIFRoZSBwcm9ibGVtIGlzIGFuYWxvZ291cyB0byBoYXZp bmcgcm9vdCBsb2cgaW50byBhIExpbnV4IGJveCBhbmQgcnVuIGFwcGxpY2F0aW9uIGNvbW1hbmRz LiAgSXQgd29ya3MsIGJ1dCBpdCBvcGVucyBhIHNlY3VyaXR5IGhvbGUsIGFzIHlvdSd2ZSBkaXNj b3ZlcmVkLg0KPg0KPj4gWWVzLCBhZ3JlZWQuIEFueSBpZGVhcz8NCj4gSW4gdGhpcyBwYXJ0aWN1 bGFyIGNhc2UgKGNyZWF0aW5nIGFuIHVudHJ1c3RlZCBQTCBhbmQgZnVuY3Rpb25zIHRoZXJlaW4p LCB5b3UnbGwgbmVlZCB0byB1c2UgYSBQb3N0Z3JlU1FMIHN1cGVydXNlci4gIFRoaXMgaXMgYSBz ZXBhcmF0ZSBvcGVyYXRpb24gZnJvbSByb3V0aW5lIGFwcGxpY2F0aW9uIHVzZSwgdGhvdWdoLiAg KEknbGwgbm90ZSB0aGF0IGhhdmluZyBmdW5jdGlvbnMgaW4gYW4gdW50cnVzdGVkIFBMIGluIGEg UENJLXNlbnNpdGl2ZSBzeXN0ZW0gaXMgbm90IGEgZ3JlYXQgaWRlYSwgYXMgeW91J2xsIG5lZWQg dG8gYXVkaXQgdGhlbSB2ZXJ5IGNsb3NlbHkgdG8gbWFrZSBzdXJlIHRoYXQgdGhleSBjYW4ndCBk byBhbnl0aGluZyB1bnRvd2FyZCBvdXRzaWRlIHRoZSByb2xlIHN5c3RlbS4pDQoNClRoYW5rIHlv dSBEYXZpZCwgTGF1cmVudHogJiBDaHJpc3RvcGhlLA0KDQpBbGwgZXhjZWxsZW50IGlucHV0cy4N Cg0KSSd2ZSByZWFsaXplZCB0aGF0IG91ciByZXBvcnRpbmcgZmVhdHVyZSBpcyB3cmFwcGVkLWJv dW5kIGluIGEgDQpUcmFuc2FjdGlvbiAmIFJvbGxiYWNrLiBUaGlzIGFjdHVhbGx5IGNhbWUgd2l0 aCBhbiBpZGVhIHRvIEFsdGVyIHRoYXQgDQpyb2xlIGFzIGEgcGFydCBvZiB0cmFuc2FjdGlvbi4N Cg0KSXQgd29ya3MgaW4gYW4gZXhjZWxsZW50IHdheSENCg0KQkVHSU4gVFJBTlNBQ1RJT047DQph bHRlciByb2xlIENVUlJFTlRfVVNFUiB3aXRoIE5PU1VQRVJVU0VSOw0Kc2VsZWN0ICogZnJvbSBw Z19yZWFkX2ZpbGUoJy9ldGMvcGFzc3dkJyAsIDAgLCAxMDAwMDAwKTsNClJPTExCQUNLIFRSQU5T QUNUSU9OOw0KQkVHSU4NCkFMVEVSIFJPTEUNCkVSUk9SOsKgIHBlcm1pc3Npb24gZGVuaWVkIGZv ciBmdW5jdGlvbiBwZ19yZWFkX2ZpbGUNClJPTExCQUNLDQpicC1ub2RlPSMNCg0KRXZlbiB0cnlp bmcgdG8gYnJlYWsgaXQgc2VlbXMgdG8gYmUgZGlmZmljdWx0Lg0KDQpCRUdJTiBUUkFOU0FDVElP TjsNCmFsdGVyIHJvbGUgQ1VSUkVOVF9VU0VSIHdpdGggTk9TVVBFUlVTRVI7DQphbHRlciByb2xl IENVUlJFTlRfVVNFUiB3aXRoIFNVUEVSVVNFUjsNClJPTExCQUNLIFRSQU5TQUNUSU9OOw0KQkVH SU4NCkFMVEVSIFJPTEUNCkVSUk9SOsKgIG11c3QgYmUgc3VwZXJ1c2VyIHRvIGFsdGVyIHN1cGVy dXNlciByb2xlcyBvciBjaGFuZ2Ugc3VwZXJ1c2VyIA0KYXR0cmlidXRlDQpST0xMQkFDSw0KDQpJ IGtub3cgaXQgaXMgbm90IGV4YWN0bHkgd2hhdCB5b3Ugc3VnZ2VzdGVkIChhbmQgYWdyZWVpbmcg YSBsb3Qgd2l0aCBvdXIgDQphcHAgdXNlciBzaG91bGRuJ3QgYmUgcnVubmluZyBhcyBzdXBlcnVz ZXIpLCBidXQgYXMgYWxsIG90aGVyIGlucHV0cyANCmZyb20gb3VyIGFwcGxpY2F0aW9uIGNvbWUg c2FuaXRpemVkIHRocm91Z2ggYmluZCBhbmQgdGhpcyBpcyB0aGUgb25seSANCndheSB3aGVyZSB1 c2VyIGNhbiBzZW5kIGFuIGV4cGxpY2l0IGNvbW1hbmQgaW4gdGhlcmUgLSBJIHRoaW5rIGl0IHNo b3VsZCBkbyENCg0KUGxlYXNlIGxldCBtZSBrbm93IGlmIHlvdSBhcHByb3ZlLg0KDQpUaGFua3Mg JiBDaGVlcnMsDQpKYW4NCg0KLS0gDQpKYW4gQmlsZWsgLSBDVE8gYXQgRUZUbGFiIFB0eSBMdGQu DQoNCg==