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 1osJ8e-0001Bx-3S for pgsql-general@arkaria.postgresql.org; Tue, 08 Nov 2022 07:35:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1osJ8b-0006Hz-KT for pgsql-general@arkaria.postgresql.org; Tue, 08 Nov 2022 07:35:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1osJ8a-0006Hk-Q6 for pgsql-general@lists.postgresql.org; Tue, 08 Nov 2022 07:35:13 +0000 Received: from mail-me3aus01on2135.outbound.protection.outlook.com ([40.107.108.135] helo=AUS01-ME3-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1osJ8W-0001hu-GE for pgsql-general@postgresql.org; Tue, 08 Nov 2022 07:35:11 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=UZzRvvXazi3S1B0b9Tgl7d9AYTYi4y+I9EKEINdGCAmExo4TMLECeTq0G0TPrYmPyaE8vyQ6DA/bNAzec/9L2OxdnGqwhkp1si2VPMATvEMfRIBIdTaN2a8ebp3eA3V5LmpJ5GNp03raJs7cwqVC6nM8QSgK7jDN5jSvMkWJHZtMTOL8u+JbYut+z0JsR5xDJgYTXYms08T7qrvfvbLPE4EPKyk7F4WcT6RXi9IQR4VINMOwqQyRrH9alrryPqNLWoExNHY/e0mumVRy1mpRSh0i9be3cxKwqStI81edOnTtK7hNdWWvKekrsLSmP4P7p+XpFujThy2pMWdWpD2S0A== 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=p83A0pn4Li8p7seO8OMnzwUYp0/ItxgurqfqDXPGt8Y=; b=RJC9ETQCuv8CbsqtzuYHPCf2VpjjPxTugJE4IZTHdhMdgay7HURERXwqavgTEbI/94oERkBnqXiG9l+QDUgWWKwvd2xa5WZdND42BL3pQrPoijqcWvrPJYHY1BnWT3nhLue3JXt4dUMko4aoVDdtwt7knUZ4/aX1G2Yi3ob9AEUi3h5LFZZcHMCUe8CRQxZJCivonAt1YW0E7zHgH1p5+v3vHeVHwvkdpnyNQsPJN6+e9djot2uyTLNgh0USdLvTr1cDKxsoh3Ylz+ulMkeNpdHZW9GS2gFw6nWcLvMnnQPuPN/X5qveP+fOOy4JnE2s1wB/vtN99rtLknZcbyIcYg== 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=p83A0pn4Li8p7seO8OMnzwUYp0/ItxgurqfqDXPGt8Y=; b=b0mrlmcAM9uM7DmG+43oYsrd868iqhDTitTmAlkVuct2lgCZm1JxYdYS+BFOvSKLBlPsNY1ovCyGpPfo/wWqXkckGXTGImjCzk+nSDDJN9i4X0YXNcrNrnr9/hJR1058Ucf4+AgLWF6e8WkZzOlNjNsaRj8A7LCm+3r23abfU3w= Received: from SY4P282MB3940.AUSP282.PROD.OUTLOOK.COM (2603:10c6:10:195::11) by SY4P282MB1225.AUSP282.PROD.OUTLOOK.COM (2603:10c6:10:a5::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5791.26; Tue, 8 Nov 2022 07:35: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 07:35:02 +0000 From: Jan Bilek To: Laurenz Albe , 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+kk6o73Esk2wlPMLLICB4K40PQcAgAADtwCAAAIBAIAAKESAgAAvT4CAAAjFAA== Date: Tue, 8 Nov 2022 07:35:02 +0000 Message-ID: <915c39ef-5244-7682-0a2e-fffe17ba8490@eftlab.com.au> References: <23C450AB-9333-40CB-8ED1-F15D15BED878@thebuild.com> <33a762ed-a045-c1e5-a042-cd4903f7de4b@eftlab.com.au> <87E0DAE2-248C-4F47-B333-436D515FD36D@thebuild.com> <96d54b77e1584463cc1c12e1a3ed6870063916b2.camel@cybertec.at> In-Reply-To: <96d54b77e1584463cc1c12e1a3ed6870063916b2.camel@cybertec.at> 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_|SY4P282MB1225:EE_ x-ms-office365-filtering-correlation-id: 92bb7b43-1238-4d72-1419-08dac15bbf77 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: uJ27YJbab3ckoLWAXxk9bhoPfzLBmxsumkYrpbXPf9VXVtONfbvxddhbq8610JF0Hs/GUQad7hK98S9jTMC9QqjvE1mJBRjEdiSIgn1m+IuQ4KFyMyScZ+6K4emocMVGc3Sqv7LlSC9eBgDSsXitdoEuN5t9qRpUSMfFkJDpFMXdGj9TCxTFE1IPr1EFmlaPI1P0Ti0kFXklvV+bhjv1EbpUgYihvE195ur+DDcr54nOfX5Yf+AiF6VMBTz/smlh+BpLYeUY/aU1LirTrqWJu71WWpwFcdznGGQhgHf1LYIw9jdqj+TApSwPnqT1A+zrD4wwxjDcP9MArEbVoDYH56/IvqKgJ+X8ph+GivYjp9dhwaO08/GD50DQUuStNau9D4A/cqYeLMgZphXwCPwvkxhiFR6CqlF1XtvgzfA3w2i8YwA3/CER33Ib5vJ7fbclKSvolzX56cmsGmPTJumEkYtKWPmxM8T++ZRTVog2vP7mHua8RRu/kH56Hhe1KPORtf/RjAW1ZaUfRRblnYtT2chuBsESq40hqvhr3JA6B0BKk+z/f4VwmFYY4HSHdRubj+k0kiVK875xcAY9gS+0WrMuT1sSNXSDPLMw2d5Jd3NLd8KSINXk5elg2jyudGfhfAwVHNSBIH2sw65WbQY1paeh5oM/chpJmBCqsag9XtzA1m42s1AwF5yeOie4AAAWxkG+1pROrnLK3UHbqIChmZmYx1SFqziXNyGnXVnnIQAlq96P19HnZL4Vdw5YnQD8t988XSyMz45o/T8LLxhJYdBJ3yxCkFCu+Shcvy1FpJxAHQ17+xKlWQcb7WR+cMmlNR5nbVzqh59asT5rSSZRGg== 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)(39830400003)(346002)(396003)(136003)(366004)(451199015)(186003)(53546011)(2906002)(6512007)(6506007)(44832011)(122000001)(2616005)(83380400001)(110136005)(71200400001)(478600001)(6486002)(38100700002)(41300700001)(5660300002)(316002)(76116006)(8936002)(4326008)(66946007)(8676002)(66556008)(66476007)(66446008)(64756008)(36756003)(38070700005)(86362001)(31696002)(31686004)(45980500001)(43740500002);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?cWZ2VkdTalN6KzlvMWxPRXlqaWs3K3JmWVQxempTemVlSmRjRTJmcFJJRm0y?= =?utf-8?B?bjlsL3VOb0ZqTlUzdDUyK2NiSUdYazh5SFFYdGFSbnU3RVhjT3JQYTZza2Rl?= =?utf-8?B?Q2xSVjVjMklUTUJYQlN0QityVmlUcm1sR0hZYmNVQkZ5bnc0OHowSi9VOXN1?= =?utf-8?B?NlRPelpXcEorejZnc0RRMlBXSkYxSjd3Misra2FTaWEvNVRuS3p6dVJhajhm?= =?utf-8?B?anhYOXROeDZsVkpoNHB1YytiQVFnaVJDY0pwWmFFcE9GWVpETW5oSHh4cjRS?= =?utf-8?B?TDE4bCtodnd4YzdWYi9HSFpZbDdodVJRSmxCQ0NKYm1rMEdsMTVJRHJkbVlj?= =?utf-8?B?cmd6UzdUS2NWVXgrWVNyVkYzd0dxbVFmTlVCSmJkZitUOXJ1QWE5ZkJPSmJJ?= =?utf-8?B?aE5mMlkrTG1SVU9FOHRBdVBWN0ovalN5RkNDdENQWVh2RmV6d2RCV1laOHlx?= =?utf-8?B?clhKbmhYSDZrRFlTb21lMWpyNGVmMzA2RW91QnRBdFRKbG1EdTRJKysyM3A3?= =?utf-8?B?SXRic1FjdXVreDJUZTlxRmk1SjZ4WFJaNU5FMUNRbVI5dHI1anZaUlRwYUZJ?= =?utf-8?B?UExJUlVYQlRsOUFweE9zbUNCbHVxNjZCUVZ1OFg1Mi9zRFMreDRERko0NWZn?= =?utf-8?B?TlRVQWMyaDNmZE5PL1UxMWFGVU02RWFNS2FxMWlUMzVlUzVOZTQveGZ3TkU1?= =?utf-8?B?UXp3T0ljZ0JYQm5ycmVVaVV3QnZSTEpuZERrUlpIeFExTGN2MEdKNVV3eDRu?= =?utf-8?B?dzBKWWJFNlVMeWU4cXdjRk5BZmZBUGZleFdydlZadTdjYXhvNzdQY0JYOWMv?= =?utf-8?B?bEpkUjFVS3ZFR0JldWc4WWJxWEJLblFVakcrRVpBbk9OTDlBeG8xTVZYTGla?= =?utf-8?B?OVhaZkhNREU4dEl3SGNaNUpyRkJJTmFHOVRWTm1QVVlPbUYvQTNHOHdsSzYy?= =?utf-8?B?MHNXUGUvMGliay84dmJjUnFXUWJCSlRqZHMxbUxkejR3d00yaVpTd24vZEN6?= =?utf-8?B?YWhNNEoySHpVQWp0d1dZd1lQSXZIbzhYcFFwbVdpSkQ5Q0ZGRUVPaXV1Wjkr?= =?utf-8?B?K25TazVWZklVWkdVZHRSSWQvaVlrcENkbWhUanZxTHppUnZFWlA0NXR6RWUy?= =?utf-8?B?SDN4Q3ZCZEx2K2xXQ2lCWDdBN1BBaFRJb1BuT1krOFhvV2ZJOWtkNDNMSzBZ?= =?utf-8?B?cEZwanFHdUZSMldBRCtUVldYL3hORzdsWHp6Y3ZEZGR6RFh0Zk9QbFE1SzIx?= =?utf-8?B?V1lZQ3FoZk1BcFN6MnZlTEJQYVVRZ0xIQ2dvdTZYYzB5OG44b1BPTFBFR2FU?= =?utf-8?B?M2FPclRYQjdrU1pIMDBsSm5sYlNJZFhxZVgzaXRtbk54OU5TWm9ZZG02bkZD?= =?utf-8?B?OVpvZTVMSjE1a3NTcGFPcURiWkNCbWVzWUxnbmdTbnBwWjJrdHZuTy9EUmZM?= =?utf-8?B?aUE1dytiTWR6VGtueUlKVS84c2d5eUhqby9leThGWlRpNlRsbGh6TVlqR2M0?= =?utf-8?B?bWtCRFVpcWxuNFdZaC9BUHp0dEw2UmNYNGFYR1AxTDMrbENOQXNKN2pSOHJ6?= =?utf-8?B?YVQ1dVlKZXFZNGhVenl2U0dyVFZxVVlLRW1PSWRJbk5zQWFqWEFvaHFHUWxl?= =?utf-8?B?WmtRSzI3SVdIRjlRZTFxbGNtU292bmpLWjZ0SGVUK0R4YVhOYUhZaEZHeU1M?= =?utf-8?B?Q2dqTm9NYkpqSUdCbVBBQXdoMzlLRHFySVZxNmw2OVNqWm5LMEVSbnlRQVIx?= =?utf-8?B?THMyeUZKMStUWXZhNlZIbnhPTHZjbVg5c01pMFl0WFhuZmRacHE0bmIyRndn?= =?utf-8?B?S1RrbjhsVTk1YUdQbHliekpmbEloSlYvQXBoU2hBN2J3RmJGa3B5TU1ENDhY?= =?utf-8?B?azc2YUgxY2xTRWREbHNwa3hWakdDYWxsOXA3TDV5QlJDT25pbWt3MHI2MWps?= =?utf-8?B?QUhqWm5qNFM4QnZ5UzFVT0lDaVZYeEZoSGNzV0ZuU1hQSzdXN1piSFRxQVhS?= =?utf-8?B?SGVrU1V4L1BXK21oRFc0QThNMDliNVdMMzZ0bTJ4d2Flb3NnUlRxaWFqQmxk?= =?utf-8?B?cXV6bk1HVC94cVFSR2Q3ZXV5eEkvQ04yaTBheW00WDNHZXZ0MDNFSktFMnlj?= =?utf-8?B?U2pOWTg2VlpLcjNCRE5yd29xdWp1ZXI0SHpFcVdBTkIzeVgrS2UxR2lSN0gw?= =?utf-8?Q?kvV6AQDuU7bTSI2WM2dhpBtEJ+JSTVmEXEk1k0h8/MvT?= Content-Type: text/plain; charset="utf-8" Content-ID: <39EF08D07C5CF443A0C4817897D33092@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: 92bb7b43-1238-4d72-1419-08dac15bbf77 X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Nov 2022 07:35:02.4470 (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: dJnsf3FJFaKAtliysfi8izDwJnVj1q+61iPN7I6EivB6a8URJ7+IDlfauwcf5aIHeBJaGCqHkhwtq1q5/2IMcg== X-MS-Exchange-Transport-CrossTenantHeadersStamped: SY4P282MB1225 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMTEvOC8yMiAxNzowMywgTGF1cmVueiBBbGJlIHdyb3RlOg0KPiBPbiBUdWUsIDIwMjItMTEt MDggYXQgMDQ6MTQgKzAwMDAsIEphbiBCaWxlayB3cm90ZToNCj4NCj4+IEkga25vdyBpdCBpcyBu b3QgZXhhY3RseSB3aGF0IHlvdSBzdWdnZXN0ZWQgKGFuZCBhZ3JlZWluZyBhIGxvdCB3aXRoIG91 cg0KPj4gYXBwIHVzZXIgc2hvdWxkbid0IGJlIHJ1bm5pbmcgYXMgc3VwZXJ1c2VyKSwgYnV0IGFz IGFsbCBvdGhlciBpbnB1dHMNCj4+IGZyb20gb3VyIGFwcGxpY2F0aW9uIGNvbWUgc2FuaXRpemVk IHRocm91Z2ggYmluZCBhbmQgdGhpcyBpcyB0aGUgb25seQ0KPj4gd2F5IHdoZXJlIHVzZXIgY2Fu IHNlbmQgYW4gZXhwbGljaXQgY29tbWFuZCBpbiB0aGVyZSAtIEkgdGhpbmsgaXQgc2hvdWxkIGRv IQ0KPj4NCj4+IFBsZWFzZSBsZXQgbWUga25vdyBpZiB5b3UgYXBwcm92ZS4NCj4gSSBzdHJvbmds eSBkaXNhcHByb3ZlLCBhbmQgYW55IHNlY3VyaXR5IGF1ZGl0IHlvdSBwYXNzIHdpdGggc3VjaCBh IHNldHVwDQo+IGlzIHdvcnRobGVzcy4gIEkgcmVwZWF0OiB0aGUgYXBwbGljYXRpb24gZG9lcyBu b3QgbmVlZCB0byBjb25uZWN0IHdpdGgNCj4gYSBzdXBlcnVzZXIuDQo+DQo+IEkgZG9uJ3QgdW5k ZXJzdGFuZCB3aGF0IHlvdSB3YW50IHRvIGRlbW9uc3RyYXRlIHdpdGggdGhlIGNvZGUgc2FtcGxl cywgb3INCj4gd2hhdCB5b3UgbWVhbiB3aGVuIHlvdSBzYXkgdGhhdCAidGhlIHVzZXIgY2FuIHNl bmQgYW4gZXhwbGljaXQgY29tbWFuZCIuDQo+DQo+IFlvdXJzLA0KPiBMYXVyZW56IEFsYmUNCg0K SW50ZXJlc3RpbmcuDQoNCkkgYWdyZWUgdGhhdCBvdXIgYXBwIHNob3VsZG4ndCBuZWVkIHN1cGVy dXNlciwgYnV0IHRoYXQgd291bGQgbWVhbiB0aGF0IA0Kc29tZSAuLi4geW91IG1hZGUgbWUgZ2l2 ZSBpdCBzb21lIHNlcmlvdXMgdGhvdWdoIGhlcmUuDQoNCkluc3RhbGxhdGlvbiBpdHNlbGYgaXMg aGFwcGVuaW5nIHVuZGVyIGVsZXZhdGVkIChyb290KSByaWdodHMuIFdlIGFyZSANCnVzaW5nIHRo ZSBwb3N0Z3JlcyBhY2NvdW50IGZvciBtb3ZpbmcgaW4gYWxsIHdoYXQncyBuZWVkZWQgKGUuZy4g dGhhdCANCnBscHl0aG9uM3UgZXh0ZW5zaW9uKS4gV2Fsa2luZyB0aG91Z2ggb3VyIGNvZGUgZm9y IG1vc3Qgb2YgdGhlIGRheSwgSSANCmNhbid0IHNlZSB3aHkgdGhhdCBzdXBlcnVzZXIgd291bGQg YmUgcmVhbGx5IG5lZWRlZC4gVGhvc2UgcGxweXRob24zdSANCmZ1bmN0aW9ucyBhcmUgd3JhcHBl ZCB1cCB1bmRlciB0aGUgaG9vZCBhbHJlYWR5LiBJJ20gc2VuZGluZyB0aGF0IGluIHRvIA0KY2hl Y2sgaWYgb3VyIFFBIHdpbGwgZmluZCBhbnl0aGluZy4NCg0KVGhhbmtzIGZvciBiZWluZyBzdHVi Ym9ybiBhYm91dCB0aGlzIQ0KDQpDaGVlcnMsDQpKYW4NCg0KLS0gDQpKYW4gQmlsZWsgLSBDVE8g YXQgRUZUbGFiIFB0eSBMdGQuDQoNCg==