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 1qWXTj-003Zj1-1c for pgsql-general@arkaria.postgresql.org; Thu, 17 Aug 2023 07:31:35 +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 1qWXTh-00EhHD-9P for pgsql-general@arkaria.postgresql.org; Thu, 17 Aug 2023 07:31:33 +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 1qWXTg-00EhAV-Si for pgsql-general@lists.postgresql.org; Thu, 17 Aug 2023 07:31:33 +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 1qWXTd-000cor-F3 for pgsql-general@lists.postgresql.org; Thu, 17 Aug 2023 07:31:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=quipsy.de; s=seg; t=1692257487; bh=RwdDzZy1SxCjMnpqwNv5xwiF0SrKSOgiRA4c14GCy8w=; h=From:To:Subject:Date:References:In-Reply-To; b=b+0HeLafiW4FWGs5NpdLwS6k+yzqDDzjQVXomdjo/GqyHeSW7d/tyUn3mwylTG2em fm+05/BatNCNq/MoSQdDsPkG5CGGDa6Y3ZDcDVVRPOKT6jkYrEhV794feqZ9AG9PD1 uGrT+Zd/3VJTMG/uAYOaYDdgdsWrjdY9ECZ0CgGvQz+W5KK+GgW2DPPxU11Ip6YImd AMH0zVU6nWayeRua4p3vq6XV7GAp+sESlAzX4QHvk+uzV7/0gnafllMT6M4/OhfDCH xbGvyIURCTOrxwvUJ2tsKAz+56EgRtaWOhv5AEZQMC4B9ougNXkiTNCRBxWooyzlTs 7qcj33JDRuz9A== Received: from ProSeS-MX2016.proses.de (Not Verified[10.147.37.34]) by mail.proses.de with Trustwave SEG (v10,0,1,2030) id ; Thu, 17 Aug 2023 09:31:27 +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; Thu, 17 Aug 2023 09:31:27 +0200 Received: from ProSeS-MX2016.proses.de ([::1]) by ProSeS-MX2016.proses.de ([::1]) with mapi id 15.01.2242.010; Thu, 17 Aug 2023 09:31:27 +0200 From: "[Quipsy] Markus Karg" To: Erik Wienhold , "pgsql-general@lists.postgresql.org" Subject: AW: AW: Cast INTEGER to BIT confusion Thread-Topic: AW: Cast INTEGER to BIT confusion Thread-Index: AdnPU7wz/gKWq6bxS6CYQv5fuMPMIQACeD4AAASolwAAAOp+gABaJGRA Date: Thu, 17 Aug 2023 07:31:27 +0000 Message-ID: <015a3586e6dc40e0b1c3a4a1f3b1e44c@quipsy.de> References: <533487381.212078.1692100096551@office.mailbox.org> <84bd46dba5ec4097ba9663f46a1e5754@quipsy.de> <400164688.228966.1692109673749@office.mailbox.org> In-Reply-To: <400164688.228966.1692109673749@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=64ddcccf a=hljXQ6ALYVQa6Cx5z6SxUg==:117 a=xqWC_Br6kY4A:10 a=O53yQbXMW-gA:10 a=IkcTkHD0fZMA:10 a=UttIx32zK-AA:10 a=epTmVMiNAAAA:8 a=DxTOPU_SXIpiNbQXsEwA:9 a=QEXdDO2ut3YA:10 a=YmdfdRTUUHsA:10 a=j2_bo9GyWw0A:10 a=YPwwaOv25YoA:10 a=f6twcVFjD4oA:10 a=9dmYsLS3PelfC_r-sVSN:22 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 SSBhbSBnaXZpbmcgdXAuIFdoaWxlIGV2ZW4gYFNFTEVDVCBjdXJyZW50X3NjaGVtYXModHJ1ZSlg IGNvcnJlY3RseSBwcmludHMgYHh4eCwgcGdfY2F0YWxvZ2AgaXQgc3RpbGwgdXNlcyB0aGUgb3Jp Z2luYWwgYml0IHR5cGUuIFRoaXMgaXMgY29tcGxldGVseSBOT1QgYXMgZGVzY3JpYmVkIGluIHRo ZSBkb2N1bWVudGF0aW9uLCB3aGVyZSBpdCBpcyBjbGVhcmx5IHRvbGQgdGhhdCBwZ19jYXRhbG9n IG9ubHkgaXMgc2VhcmNoZWQgaW1tZWRpYXRlbHkgaWYgTk9UIGZvdW5kIGluIHRoZSBzZWFyY2gg cGF0aC4gSXQgc2VlbXMgaXQgaXMgc2ltcGx5IGltcG9zc2libGUgdG8gcnVuIHRoaXMgYXBwbGlj YXRpb24gb24gUG9zdGdyZVNRTCwgYW5kIHdlIGhhdmUgdG8gc3RpY2sgd2l0aCBhIGRpZmZlcmVu dCBSREJNUy4gVmVyeSBzYWQuDQotTWFya3VzDQoNCg0KLS0tLS1VcnNwcsO8bmdsaWNoZSBOYWNo cmljaHQtLS0tLQ0KVm9uOiBFcmlrIFdpZW5ob2xkIDxld2llQGV3aWUubmFtZT4gDQpHZXNlbmRl dDogRGllbnN0YWcsIDE1LiBBdWd1c3QgMjAyMyAxNjoyOA0KQW46IFtRdWlwc3ldIE1hcmt1cyBL YXJnIDxrYXJnQHF1aXBzeS5kZT47IHBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmcN CkJldHJlZmY6IFJlOiBBVzogQ2FzdCBJTlRFR0VSIHRvIEJJVCBjb25mdXNpb24NCg0KPiBPbiAx NS8wOC8yMDIzIDE0OjAyIENFU1QgW1F1aXBzeV0gTWFya3VzIEthcmcgPGthcmdAcXVpcHN5LmRl PiB3cm90ZToNCj4NCj4gSSBqdXN0IHRyaWVkIG91dCB5b3VyIHByb3Bvc2FsIG9uIFBvc3RncmVT UUwgMTUuMyBhbmQgdGhpcyBpcyB0aGUgcmVzdWx0Og0KPg0KPiBFUlJPUjogIGNvbHVtbiAiYyIg aXMgb2YgdHlwZSBiaXQgYnV0IGV4cHJlc3Npb24gaXMgb2YgdHlwZSBpbnRlZ2VyDQo+IExJTkUg NTogICBJTlNFUlQgSU5UTyB0IFZBTFVFUyAoMSk7DQo+ICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgXg0KPiBISU5UOiAgWW91IHdpbGwgbmVlZCB0byByZXdyaXRlIG9yIGNhc3QgdGhl IGV4cHJlc3Npb24uDQo+DQo+IEFwcGFyZW50bHkgdGhlIHNlYXJjaCBwYXRoIGlzIGlnbm9yZWQ/ IQ0KPg0KPiAtLS0tLVVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNodC0tLS0tDQo+IFZvbjogRXJpayBX aWVuaG9sZCA8ZXdpZUBld2llLm5hbWU+DQo+IEdlc2VuZGV0OiBEaWVuc3RhZywgMTUuIEF1Z3Vz dCAyMDIzIDEzOjQ4DQo+IEFuOiBbUXVpcHN5XSBNYXJrdXMgS2FyZyA8a2FyZ0BxdWlwc3kuZGU+ OyANCj4gcGdzcWwtZ2VuZXJhbEBsaXN0cy5wb3N0Z3Jlc3FsLm9yZw0KPiBCZXRyZWZmOiBSZTog Q2FzdCBJTlRFR0VSIHRvIEJJVCBjb25mdXNpb24NCj4NCj4gWW91IGNvdWxkIGNyZWF0ZSBhIGN1 c3RvbSBkb21haW4gaWYgeW91J3JlIG9ubHkgaW50ZXJlc3RlZCBpbiB2YWx1ZXMgMCANCj4gYW5k IDEgYW5kIGRvbid0IHVzZSBiaXQgc3RyaW5nIGZ1bmN0aW9ucy4gIFRoZSBzZWFyY2ggcGF0aCBt dXN0IGJlIA0KPiBjaGFuZ2VkIHNvIHRoYXQgZG9tYWluIGJpdCBvdmVycmlkZXMgcGdfY2F0YWxv Zy5iaXQ6DQo+IA0KPiAJPSMgQ1JFQVRFIFNDSEVNQSB4eHg7DQo+IAk9IyBDUkVBVEUgRE9NQUlO IHh4eC5iaXQgQVMgaW50Ow0KPiAJPSMgU0VUIHNlYXJjaF9wYXRoID0geHh4LCBwZ19jYXRhbG9n Ow0KPiAJPSMgQ1JFQVRFIFRBQkxFIHQgKGMgYml0KTsNCj4gCT0jIElOU0VSVCBJTlRPIHQgVkFM VUVTICgxKTsNCj4gCUlOU0VSVCAwIDENCj4NCj4gQnV0IEkgd291bGQgZG8gdGhhdCBvbmx5IGlm IHRoZSB0aGlyZC1wYXJ0eSBjb2RlIGNhbm5vdCBiZSB0d2Vha2VkIA0KPiBiZWNhdXNlIHRoZSBj dXN0b20gZG9tYWluIGNvdWxkIGJlIGNvbmZ1c2luZy4gIEl0J3MgYWxzbyBwcm9uZSB0byANCj4g ZXJyb3JzIGFzIGl0IHJlbGllcyBvbiBhIHNwZWNpZmljIHNlYXJjaCBwYXRoIG9yZGVyLiAgQWxz byBtYWtlIHN1cmUgDQo+IHRoYXQgcmVndWxhciB1c2VycyBjYW5ub3QgY3JlYXRlIG9iamVjdHMg aW4gc2NoZW1hIHh4eCB0aGF0IHdvdWxkIG92ZXJyaWRlIG9iamVjdHMgaW4gcGdfY2F0YWxvZy4N Cg0KSG1tLCBJIHRob3VnaHQgdGhhdCBQb3N0Z3JlcyByZXNvbHZlcyBhbGwgdHlwZXMgdGhyb3Vn aCB0aGUgc2VhcmNoIHBhdGgsIGJ1dCBhcHBhcmVudGx5IHRoYXQgaXMgbm90IHRoZSBjYXNlIGZv ciBidWlsdC1pbiB0eXBlcy4gIEkgbmV2ZXIgdXNlZCB0aGlzIHRvIG92ZXJyaWRlIGJ1aWx0LWlu IHR5cGVzIHNvIHRoaXMgaXMgYSBzdXJwcmlzZSB0byBtZS4gIChBbmQgb2J2aW91c2x5IEkgaGF2 ZW4ndCB0ZXN0ZWQgdGhlIHNlYXJjaCBwYXRoIGZlYXR1cmUgYmVmb3JlIHBvc3RpbmcuKQ0KDQpO ZWl0aGVyIFsxXSBvciBbMl0gbWVudGlvbiB0aGF0IHNwZWNpYWwgKD8pIGNhc2Ugb3IgaWYgdGhl cmUncyBhIGRpc3RpbmN0aW9uIGJldHdlZW4gYnVpbHQtaW4gdHlwZXMgYW5kIHVzZXItZGVmaW5l ZCB0eXBlcy4gIFRoZSBVU0FHRSBwcml2aWxlZ2UgaXMgcmVxdWlyZWQgYWNjb3JkaW5nIHRvIFsy XSBidXQgSSB3YXMgdGVzdGluZyBhcyBzdXBlcnVzZXIgYW55d2F5Lg0KDQpbMV0gaHR0cHM6Ly93 d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xNS9kZGwtc2NoZW1hcy5odG1sDQpbMl0gaHR0cHM6Ly93 d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xNS9ydW50aW1lLWNvbmZpZy1jbGllbnQuaHRtbCNHVUMt U0VBUkNILVBBVEgNCg0KLS0NCkVyaWsNCg==