Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qVshf-001THA-8p for pgsql-general@arkaria.postgresql.org; Tue, 15 Aug 2023 11:59:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qVshd-00Dos3-Un for pgsql-general@arkaria.postgresql.org; Tue, 15 Aug 2023 11:59:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qVshd-00Doru-IT for pgsql-general@lists.postgresql.org; Tue, 15 Aug 2023 11:59:13 +0000 Received: from mail.proses.de ([87.234.246.173]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qVshb-000HIy-4s for pgsql-general@lists.postgresql.org; Tue, 15 Aug 2023 11:59:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=quipsy.de; s=seg; t=1692100749; bh=kl1nGepGCEeoefMgtDSmE3GsSbOM/Iqh/6HmrIGMsgg=; h=From:To:Subject:Date:References:In-Reply-To; b=aKFZANZ1Ojno7vb06YWsxDPx69eku/hdVhzK9e12HKROyaUqgP6oeYz27JHjpzZt/ wAtkEfRMSS8i1VxeUb+BLx1LOlYV07b0ngRWgTojg0Wj/zTikgOp7hdxl2Tg4anInG 8wzb1851csYcbVBRTkLh3vDNiLcQZRs04TivWFhoL5MOJnRo02/NC5VimzTsTtMShc 9Tw6MIuBOcBziUUUkLOyreZgg3gw1h4cTpAS+2cvR7Q1dSBx7OrJmeNrF3Du0mUxth X6Qlg2euwZNbxS/qa5aZeG3Qgzk7jRY7mi7tEu/AUvMg7xpT8qihB8g2seRN2mv/sD BiawSewsgUGfg== Received: from ProSeS-MX2016.proses.de (Not Verified[10.147.37.34]) by mail.proses.de with Trustwave SEG (v10,0,1,2030) id ; Tue, 15 Aug 2023 13:59:09 +0200 Received: from ProSeS-MX2016.proses.de (10.147.37.34) by ProSeS-MX2016.proses.de (10.147.37.34) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.1.2242.10; Tue, 15 Aug 2023 13:59:08 +0200 Received: from ProSeS-MX2016.proses.de ([::1]) by ProSeS-MX2016.proses.de ([::1]) with mapi id 15.01.2242.010; Tue, 15 Aug 2023 13:59:08 +0200 From: "[Quipsy] Markus Karg" To: "pgsql-general@lists.postgresql.org" Subject: AW: Cast INTEGER to BIT confusion Thread-Topic: Cast INTEGER to BIT confusion Thread-Index: AdnPU7wz/gKWq6bxS6CYQv5fuMPMIQACeD4AAASCcFA= Date: Tue, 15 Aug 2023 11:59:08 +0000 Message-ID: References: <533487381.212078.1692100096551@office.mailbox.org> In-Reply-To: <533487381.212078.1692100096551@office.mailbox.org> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.147.32.78] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-SEG-SpamProfiler-Analysis: v=2.4 cv=acffITkt c=1 sm=1 tr=0 ts=64db688d a=hljXQ6ALYVQa6Cx5z6SxUg==:117 a=xqWC_Br6kY4A:10 a=O53yQbXMW-gA:10 a=IkcTkHD0fZMA:10 a=UttIx32zK-AA:10 a=epTmVMiNAAAA:8 a=FsUHXJQ54X4ylXZ7msEA:9 a=QEXdDO2ut3YA:10 a=ndEWmUVY6Yapc0oHF_P4:22 X-SEG-SpamProfiler-Score: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhhbmsgeW91LCBFcmlrISBQcmVmaXhpbmcgdGhlIHNlYXJjaCBwYXRoIGluIGZhY3QgbG9va3Mg dmVyeSBpbnRlcmVzdGluZywgYW5kIEkgdGhpbmsgaW4gdGhpcyBwYXJ0aWN1bGFyIGFwcGxpY2F0 aW9uIGl0IGlzIGEgc2FmZSAoYW5kIHRoZSBvbmx5KSBzb2x1dGlvbi4NCg0KSXMgc2V0dGluZyB0 aGUgc2VhcmNoIHBhdGggc29tZXRoaW5nIHRoYXQgaGFzIHRvIGJlIGRvbmUgZm9yIGVhY2ggbmV3 IGNvbm5lY3Rpb24gLyBlYWNoIHVzZXIsIG9yIGlzIHRoaXMgc29tZXRoaW5nIHN0YXRpYyBhbmQg Z2xvYmFsIGZvciB0aGUgZGF0YWJhc2U/DQoNClRoYW5rcyBhIGxvdCENCi1NYXJrdXMNCg0KDQot LS0tLVVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNodC0tLS0tDQpWb246IEVyaWsgV2llbmhvbGQgPGV3 aWVAZXdpZS5uYW1lPiANCkdlc2VuZGV0OiBEaWVuc3RhZywgMTUuIEF1Z3VzdCAyMDIzIDEzOjQ4 DQpBbjogW1F1aXBzeV0gTWFya3VzIEthcmcgPGthcmdAcXVpcHN5LmRlPjsgcGdzcWwtZ2VuZXJh bEBsaXN0cy5wb3N0Z3Jlc3FsLm9yZw0KQmV0cmVmZjogUmU6IENhc3QgSU5URUdFUiB0byBCSVQg Y29uZnVzaW9uDQoNCj4gT24gMTUvMDgvMjAyMyAxMDo0OSBDRVNUIFtRdWlwc3ldIE1hcmt1cyBL YXJnIDxrYXJnQHF1aXBzeS5kZT4gd3JvdGU6DQo+DQo+IEhlbGxvIFBvc3RncmVTUUwgQ29tbXVu aXR5LA0KPg0KPiBJIGxpa2UgdG8gc3RvcmUganVzdCBhIHNpbmdsZSBiaXQgYnV0IHRoYXQgY2Fu IGJlIGVpdGhlciAxIG9yIDAsIHNvIEkgDQo+IHRyaWVkIHRvIGRvIHRoaXM6DQo+DQo+IENSRUFU RSBUQUJMRSBUIChjIEJJVCk7DQo+IElOU0VSVCBJTlRPIFQgVkFMVUVTICgxKTsNCj4gLS0gSSBN VVNUIE5PVCBjaGFuZ2UgYm90aCBsaW5lcyBpbiBhbnkgd2F5IGFzIHRoZXNlIGFyZSBwYXJ0IG9m IGEgdGhpcmQtcGFydHkgYXBwbGljYXRpb24hDQo+DQo+IFVuZm9ydHVuYXRlbHkgdGhpcyB0ZWxs cyBtZToNCj4NCj4gY29sdW1uICJjIiBpcyBvZiB0eXBlIGJpdCBidXQgZXhwcmVzc2lvbiBpcyBv ZiB0eXBlIGludGVnZXINCj4NCj4gU28gSSBsb2dnZWQgaW4gYXMgYSBjbHVzdGVyIGFkbWluIGFu ZCBJIHRyaWVkIHRoaXM6DQo+DQo+IENSRUFURSBDQVNUIChpbnRlZ2VyIEFTIGJpdCkgV0lUSCBJ Tk9VVCBBUyBJTVBMSUNJVDsNCj4NCj4gVW5mb3J0dW5hdGVseSB0aGF0IHRlbGxzIG1lOg0KPg0K PiBjYXN0IGZyb20gdHlwZSBpbnRlZ2VyIHRvIHR5cGUgYml0IGFscmVhZHkgZXhpc3RzDQo+DQo+ IFRoaXMgaXMgY29uZnVzaW5nISBBcHBhcmVudGx5IFBvc3RncmVTUUwgMTUuMyBjb21lcyB3aXRo IHRoZSBuZWVkZWQgDQo+IGNhc3Qgb3V0LW9mLXRoZS1ib3ggYnV0IGl0IGRvZXMgbm90IGFwcGx5 IGl0PyBUaGlzIGlzIGNvbmZ1c2luZyENCj4NCj4gV2hhdCBpcyBteSBmYXVsdD8NCg0KVGhlIGJ1 aWx0LWluIGNhc3QgaXMgZXhwbGljaXQgKGNhc3Rjb250ZXh0ID0gJ2UnKToNCg0KCT0jIFNFTEVD VCAqIEZST00gcGdfY2FzdCBXSEVSRSBjYXN0c291cmNlID0gJ2ludCc6OnJlZ3R5cGUgQU5EIGNh c3R0YXJnZXQgPSAnYml0Jzo6cmVndHlwZTsNCgkgIG9pZCAgfCBjYXN0c291cmNlIHwgY2FzdHRh cmdldCB8IGNhc3RmdW5jIHwgY2FzdGNvbnRleHQgfCBjYXN0bWV0aG9kDQoJLS0tLS0tLSstLS0t LS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0t LS0NCgkgMTAxODYgfCAgICAgICAgIDIzIHwgICAgICAgMTU2MCB8ICAgICAxNjgzIHwgZSAgICAg ICAgICAgfCBmDQoJKDEgcm93KQ0KDQpJdCdzIG5vdCBwb3NzaWJsZSB0byBkcm9wIHRoYXQgY2Fz dCBhbmQgcmVwbGFjZSBpdCB3aXRoIGEgY3VzdG9tIG9uZToNCg0KCT0jIERST1AgQ0FTVCAoaW50 IEFTIGJpdCk7DQoJRVJST1I6ICBjYW5ub3QgZHJvcCBjYXN0IGZyb20gaW50ZWdlciB0byBiaXQg YmVjYXVzZSBpdCBpcyByZXF1aXJlZCBieSB0aGUgZGF0YWJhc2Ugc3lzdGVtDQoNCllvdSBjb3Vs ZCBjcmVhdGUgYSBjdXN0b20gZG9tYWluIGlmIHlvdSdyZSBvbmx5IGludGVyZXN0ZWQgaW4gdmFs dWVzIDAgYW5kIDEgYW5kIGRvbid0IHVzZSBiaXQgc3RyaW5nIGZ1bmN0aW9ucy4gIFRoZSBzZWFy Y2ggcGF0aCBtdXN0IGJlIGNoYW5nZWQgc28gdGhhdCBkb21haW4gYml0IG92ZXJyaWRlcyBwZ19j YXRhbG9nLmJpdDoNCg0KCT0jIENSRUFURSBTQ0hFTUEgeHh4Ow0KCT0jIENSRUFURSBET01BSU4g eHh4LmJpdCBBUyBpbnQ7DQoJPSMgU0VUIHNlYXJjaF9wYXRoID0geHh4LCBwZ19jYXRhbG9nOw0K CT0jIENSRUFURSBUQUJMRSB0IChjIGJpdCk7DQoJPSMgSU5TRVJUIElOVE8gdCBWQUxVRVMgKDEp Ow0KCUlOU0VSVCAwIDENCg0KQnV0IEkgd291bGQgZG8gdGhhdCBvbmx5IGlmIHRoZSB0aGlyZC1w YXJ0eSBjb2RlIGNhbm5vdCBiZSB0d2Vha2VkIGJlY2F1c2UgdGhlIGN1c3RvbSBkb21haW4gY291 bGQgYmUgY29uZnVzaW5nLiAgSXQncyBhbHNvIHByb25lIHRvIGVycm9ycyBhcyBpdCByZWxpZXMg b24gYSBzcGVjaWZpYyBzZWFyY2ggcGF0aCBvcmRlci4gIEFsc28gbWFrZSBzdXJlIHRoYXQgcmVn dWxhciB1c2VycyBjYW5ub3QgY3JlYXRlIG9iamVjdHMgaW4gc2NoZW1hIHh4eCB0aGF0IHdvdWxk IG92ZXJyaWRlIG9iamVjdHMgaW4gcGdfY2F0YWxvZy4NCg0KLS0NCkVyaWsNCg==