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 1qVsks-001TUe-5Y for pgsql-general@arkaria.postgresql.org; Tue, 15 Aug 2023 12:02:34 +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 1qVskq-00DtNp-RX for pgsql-general@arkaria.postgresql.org; Tue, 15 Aug 2023 12:02:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qVskq-00DtNf-GV for pgsql-general@lists.postgresql.org; Tue, 15 Aug 2023 12:02:32 +0000 Received: from mail.proses.de ([87.234.246.173]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qVski-000Fss-NU for pgsql-general@lists.postgresql.org; Tue, 15 Aug 2023 12:02:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=quipsy.de; s=seg; t=1692100942; bh=Aj67y62VMoSZ+8JRAuNIMa+78y29EpkQ+CyuNPGteo8=; h=From:To:Subject:Date:References:In-Reply-To; b=jzosRqhLFsUzA0OXwhcTrxLo25s+VR83wc2x90HSzHAULSKb4LnQFA022XMXFHzf6 CTHG+wYaaIjo68p0ka2Pk0H4/HAY0Gm3lwD0P0GFtZr8l352p99GEs5yO2gNJ0u1/g grRR+/3Jr2i+RyNcAQki80grZfumiJLurjv0tNHhsbpgttA57dZyGkBj/kapcy+EtB Q4CByf71PWmOeCbNariW0Gq6SQQYNp/GXQpnSTgyhuPm2zLtjckg5fhRJnkxwVMkb5 bA0ZNU5OQNnl7TqoMLCrApLMVWjJq7DauY9lL5mJQ53GTtzcAcbe+AlHbz+NSNInMD uPlk2AA7zYdSw== 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 14:02:22 +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 14:02:22 +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 14:02:21 +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/gKWq6bxS6CYQv5fuMPMIQACeD4AAASolwA= Date: Tue, 15 Aug 2023 12:02:21 +0000 Message-ID: <84bd46dba5ec4097ba9663f46a1e5754@quipsy.de> 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=64db694e 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 RXJpaywNCg0KSSBqdXN0IHRyaWVkIG91dCB5b3VyIHByb3Bvc2FsIG9uIFBvc3RncmVTUUwgMTUu MyBhbmQgdGhpcyBpcyB0aGUgcmVzdWx0Og0KDQpFUlJPUjogIGNvbHVtbiAiYyIgaXMgb2YgdHlw ZSBiaXQgYnV0IGV4cHJlc3Npb24gaXMgb2YgdHlwZSBpbnRlZ2VyDQpMSU5FIDU6ICAgSU5TRVJU IElOVE8gdCBWQUxVRVMgKDEpOw0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBeDQpI SU5UOiAgWW91IHdpbGwgbmVlZCB0byByZXdyaXRlIG9yIGNhc3QgdGhlIGV4cHJlc3Npb24uDQoN CkFwcGFyZW50bHkgdGhlIHNlYXJjaCBwYXRoIGlzIGlnbm9yZWQ/IQ0KDQotTWFya3VzDQoNCi0t LS0tVXJzcHLDvG5nbGljaGUgTmFjaHJpY2h0LS0tLS0NClZvbjogRXJpayBXaWVuaG9sZCA8ZXdp ZUBld2llLm5hbWU+IA0KR2VzZW5kZXQ6IERpZW5zdGFnLCAxNS4gQXVndXN0IDIwMjMgMTM6NDgN CkFuOiBbUXVpcHN5XSBNYXJrdXMgS2FyZyA8a2FyZ0BxdWlwc3kuZGU+OyBwZ3NxbC1nZW5lcmFs QGxpc3RzLnBvc3RncmVzcWwub3JnDQpCZXRyZWZmOiBSZTogQ2FzdCBJTlRFR0VSIHRvIEJJVCBj b25mdXNpb24NCg0KPiBPbiAxNS8wOC8yMDIzIDEwOjQ5IENFU1QgW1F1aXBzeV0gTWFya3VzIEth cmcgPGthcmdAcXVpcHN5LmRlPiB3cm90ZToNCj4NCj4gSGVsbG8gUG9zdGdyZVNRTCBDb21tdW5p dHksDQo+DQo+IEkgbGlrZSB0byBzdG9yZSBqdXN0IGEgc2luZ2xlIGJpdCBidXQgdGhhdCBjYW4g YmUgZWl0aGVyIDEgb3IgMCwgc28gSSANCj4gdHJpZWQgdG8gZG8gdGhpczoNCj4NCj4gQ1JFQVRF IFRBQkxFIFQgKGMgQklUKTsNCj4gSU5TRVJUIElOVE8gVCBWQUxVRVMgKDEpOw0KPiAtLSBJIE1V U1QgTk9UIGNoYW5nZSBib3RoIGxpbmVzIGluIGFueSB3YXkgYXMgdGhlc2UgYXJlIHBhcnQgb2Yg YSB0aGlyZC1wYXJ0eSBhcHBsaWNhdGlvbiENCj4NCj4gVW5mb3J0dW5hdGVseSB0aGlzIHRlbGxz IG1lOg0KPg0KPiBjb2x1bW4gImMiIGlzIG9mIHR5cGUgYml0IGJ1dCBleHByZXNzaW9uIGlzIG9m IHR5cGUgaW50ZWdlcg0KPg0KPiBTbyBJIGxvZ2dlZCBpbiBhcyBhIGNsdXN0ZXIgYWRtaW4gYW5k IEkgdHJpZWQgdGhpczoNCj4NCj4gQ1JFQVRFIENBU1QgKGludGVnZXIgQVMgYml0KSBXSVRIIElO T1VUIEFTIElNUExJQ0lUOw0KPg0KPiBVbmZvcnR1bmF0ZWx5IHRoYXQgdGVsbHMgbWU6DQo+DQo+ IGNhc3QgZnJvbSB0eXBlIGludGVnZXIgdG8gdHlwZSBiaXQgYWxyZWFkeSBleGlzdHMNCj4NCj4g VGhpcyBpcyBjb25mdXNpbmchIEFwcGFyZW50bHkgUG9zdGdyZVNRTCAxNS4zIGNvbWVzIHdpdGgg dGhlIG5lZWRlZCANCj4gY2FzdCBvdXQtb2YtdGhlLWJveCBidXQgaXQgZG9lcyBub3QgYXBwbHkg aXQ/IFRoaXMgaXMgY29uZnVzaW5nIQ0KPg0KPiBXaGF0IGlzIG15IGZhdWx0Pw0KDQpUaGUgYnVp bHQtaW4gY2FzdCBpcyBleHBsaWNpdCAoY2FzdGNvbnRleHQgPSAnZScpOg0KDQoJPSMgU0VMRUNU ICogRlJPTSBwZ19jYXN0IFdIRVJFIGNhc3Rzb3VyY2UgPSAnaW50Jzo6cmVndHlwZSBBTkQgY2Fz dHRhcmdldCA9ICdiaXQnOjpyZWd0eXBlOw0KCSAgb2lkICB8IGNhc3Rzb3VyY2UgfCBjYXN0dGFy Z2V0IHwgY2FzdGZ1bmMgfCBjYXN0Y29udGV4dCB8IGNhc3RtZXRob2QNCgktLS0tLS0tKy0tLS0t LS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0t LQ0KCSAxMDE4NiB8ICAgICAgICAgMjMgfCAgICAgICAxNTYwIHwgICAgIDE2ODMgfCBlICAgICAg ICAgICB8IGYNCgkoMSByb3cpDQoNCkl0J3Mgbm90IHBvc3NpYmxlIHRvIGRyb3AgdGhhdCBjYXN0 IGFuZCByZXBsYWNlIGl0IHdpdGggYSBjdXN0b20gb25lOg0KDQoJPSMgRFJPUCBDQVNUIChpbnQg QVMgYml0KTsNCglFUlJPUjogIGNhbm5vdCBkcm9wIGNhc3QgZnJvbSBpbnRlZ2VyIHRvIGJpdCBi ZWNhdXNlIGl0IGlzIHJlcXVpcmVkIGJ5IHRoZSBkYXRhYmFzZSBzeXN0ZW0NCg0KWW91IGNvdWxk IGNyZWF0ZSBhIGN1c3RvbSBkb21haW4gaWYgeW91J3JlIG9ubHkgaW50ZXJlc3RlZCBpbiB2YWx1 ZXMgMCBhbmQgMSBhbmQgZG9uJ3QgdXNlIGJpdCBzdHJpbmcgZnVuY3Rpb25zLiAgVGhlIHNlYXJj aCBwYXRoIG11c3QgYmUgY2hhbmdlZCBzbyB0aGF0IGRvbWFpbiBiaXQgb3ZlcnJpZGVzIHBnX2Nh dGFsb2cuYml0Og0KDQoJPSMgQ1JFQVRFIFNDSEVNQSB4eHg7DQoJPSMgQ1JFQVRFIERPTUFJTiB4 eHguYml0IEFTIGludDsNCgk9IyBTRVQgc2VhcmNoX3BhdGggPSB4eHgsIHBnX2NhdGFsb2c7DQoJ PSMgQ1JFQVRFIFRBQkxFIHQgKGMgYml0KTsNCgk9IyBJTlNFUlQgSU5UTyB0IFZBTFVFUyAoMSk7 DQoJSU5TRVJUIDAgMQ0KDQpCdXQgSSB3b3VsZCBkbyB0aGF0IG9ubHkgaWYgdGhlIHRoaXJkLXBh cnR5IGNvZGUgY2Fubm90IGJlIHR3ZWFrZWQgYmVjYXVzZSB0aGUgY3VzdG9tIGRvbWFpbiBjb3Vs ZCBiZSBjb25mdXNpbmcuICBJdCdzIGFsc28gcHJvbmUgdG8gZXJyb3JzIGFzIGl0IHJlbGllcyBv biBhIHNwZWNpZmljIHNlYXJjaCBwYXRoIG9yZGVyLiAgQWxzbyBtYWtlIHN1cmUgdGhhdCByZWd1 bGFyIHVzZXJzIGNhbm5vdCBjcmVhdGUgb2JqZWN0cyBpbiBzY2hlbWEgeHh4IHRoYXQgd291bGQg b3ZlcnJpZGUgb2JqZWN0cyBpbiBwZ19jYXRhbG9nLg0KDQotLQ0KRXJpaw0K