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 1oRJdq-0003C4-Vq for pgsql-admin@arkaria.postgresql.org; Thu, 25 Aug 2022 20:39:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oRJdp-00014W-P5 for pgsql-admin@arkaria.postgresql.org; Thu, 25 Aug 2022 20:39:53 +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 1oRJdp-00014M-Dt for pgsql-admin@lists.postgresql.org; Thu, 25 Aug 2022 20:39:53 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oRJdk-00030E-IW for pgsql-admin@lists.postgresql.org; Thu, 25 Aug 2022 20:39:53 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 3FB5C380876; Thu, 25 Aug 2022 22:39:47 +0200 (CEST) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id bu5P0FlMATg1; Thu, 25 Aug 2022 22:39:47 +0200 (CEST) Received: from [192.168.178.86] (p5b249d86.dip0.t-ipconnect.de [91.36.157.134]) by rs.plausibolo.de (Postfix) with ESMTPSA id EBBAD380733; Thu, 25 Aug 2022 22:39:46 +0200 (CEST) Message-ID: Date: Thu, 25 Aug 2022 22:39:46 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.1.2 To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs Subject: Re: postgresql statement problem In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------R9SsOEQ6L0oqBDiZjHUlzNm3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------R9SsOEQ6L0oqBDiZjHUlzNm3 Content-Type: multipart/mixed; boundary="------------12xCtSQbtp4yc7Rc24L0mrKO"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: Subject: Re: postgresql statement problem References: In-Reply-To: --------------12xCtSQbtp4yc7Rc24L0mrKO Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMjUuMDguMjIgdW0gMjI6MzEgc2NocmllYiBsaWFtIHNhZmZpb3RpOg0KPiBIZWxsbyBU ZWFtLA0KPg0KPiBJIGFtIHVzaW5nIFBHIDE0LjUsIGFuZCBJIGhhdmUgYSBwcm9ibGVtIHdp dGggY29ubmVjdGlvbi4gQSBjb25uZWN0aW9uIA0KPiB3b3JrcyBtb3JlIHRoYW4gMiBob3Vy cyBldmVuIHRob3VnaCBpdCdzIGxpbWl0ZWQgdG8gdHdvIGhvdXJzLiBIb3cgaXMgDQo+IHRo aXMgcG9zc2libGU/wqAgVGhlIGRldGFpbCBpcyBiZWxvdzoNCj4gKERXSCB1c2VyIGlzIG5v dCBhIHN1cGVydXNlciwgaXQgaXMgYSBzdGFuZGFyZMKgdXNlciB0aGF0IGhhcyBzZWxlY3Qg DQo+IG9ubHkgcHJpdmlsZWdlLikNCj4NCj4gc2hvdyBzdGF0ZW1lbnRfdGltZW91dCA7DQo+ IMKgc3RhdGVtZW50X3RpbWVvdXQNCj4gLS0tLS0tLS0tLS0tLS0tLS0tLQ0KPiDCoDJoDQo+ DQo+IHNob3cgbWF4X3N0YW5kYnlfYXJjaGl2ZV9kZWxheSA7DQo+IMKgbWF4X3N0YW5kYnlf YXJjaGl2ZV9kZWxheQ0KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCj4gwqAyaA0K Pg0KPiBzaG93IG1heF9zdGFuZGJ5X3N0cmVhbWluZ19kZWxheSA7DQo+IMKgbWF4X3N0YW5k Ynlfc3RyZWFtaW5nX2RlbGF5DQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQo+ IMKgMmgNCj4NCj4gU0VMRUNUIHVzZW5hbWUsIHN0YXRlLHdhaXRfZXZlbnQsIA0KPiBiYWNr ZW5kX3htaW4seGFjdF9zdGFydCxxdWVyeV9zdGFydCxzdGF0ZV9jaGFuZ2Usbm93KCkgRlJP TSANCj4gcGdfc3RhdF9hY3Rpdml0eSBXSEVSRSBiYWNrZW5kX3htaW4gSVMgTk9UIE5VTEwg T1JERVIgQlkgDQo+IGFnZShiYWNrZW5kX3htaW4pIERFU0M7DQo+IMKgdXNlbmFtZSDCoCDC oCB8IMKgIMKgIMKgIMKgc3RhdGUgwqAgwqAgwqAgwqB8IGNsaWVudF9hZGRyIMKgfCB3YWl0 X2V2ZW50IMKgfCANCj4gYmFja2VuZF94bWluIHwgwqAgwqAgwqAgwqAgwqB4YWN0X3N0YXJ0 IMKgIMKgIMKgIMKgIMKgIHwgwqBxdWVyeV9zdGFydCDCoCDCoCDCoCDCoCDCoHwgDQo+IMKg IMKgIMKgIMKgIHN0YXRlX2NoYW5nZSDCoCDCoHwgbm93DQo+IC0tLS0tLS0tKy0tLS0tLS0t LS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0tLS0t LS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0r LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCj4gRFdIwqAgwqB8 IGlkbGUgaW4gdHJhbnNhY3Rpb24gwqB8IENsaWVudFJlYWQgwqB8IMKgNDc3MzAyNjcgfCAy MDIyLTA4LTI1IA0KPiAyMTowMzowMi45NjEzMDkrMDMgfCAyMDIyLTA4LTI1IDIxOjA1OjMy LjI3Nzk2KzAzIMKgfCAyMDIyLTA4LTI1IA0KPiAyMTowNTozMi4yODU3MjkrMDMgfCAyMDIy LTA4LTI1IDIzOjIyOjI0LjgzMDgyOQ0KPiBEV0jCoCDCoHwgYWN0aXZlIMKgIMKgIMKgIMKg IMKgIMKgIMKgIHwgQ2xpZW50V3JpdGUgfCDCoDQ3NzMwMjY3IHwgMjAyMi0wOC0yNSANCj4g MjE6MDM6NTYuOTg0MTg5KzAzIHwgMjAyMi0wOC0yNSAyMTowMzo1Ny4wNjIzMjkrMDMgfCAy MDIyLTA4LTI1IA0KPiAyMTowMzo1Ny4wNjIzMjkrMDMgfCAyMDIyLTA4LTI1IDIzOjIyOjI0 LjgzMDgyOQ0KDQpZb3UgaGF2ZSBzZXQgYSBzdGF0ZW1lbnQgdGltZW91dCwgYnV0IGNvbXBs YWluIHRoYXQgYSBjb25uZWN0aW9uIA0KKHNlc3Npb24/KSB0YWtlcyBsb25nZXIsDQoNClVu Zm9ydHVuYXRlbHksIHRoZSBzdGF0ZW1lbnQgYW5kIHRoZSB0YWJsZSB5b3UgcG9zdGVkIGRv bid0IG1hdGNoLiBQbHVzLCANCnRoZSB0YWJsZSBpcyB2ZXJ5IHdpZGUgYW5kIGFsbW9zdCBp bGxlZ2libGUuDQoNClBsZWFzZSB1c2Ugb3B0aW9uIFx4IG9mIHBzcWwgdG8gcHJvZHVjZSBh IGJldHRlciBvdXRwdXQuDQoNClJlZ2FyZHMsDQoNCkhvbGdlcg0KDQo+DQotLSANCkhvbGdl ciBKYWtvYnMsIEJlcmdpc2NoIEdsYWRiYWNoLCBUZWwuICs0OS0xNzgtOTc1OTAxMg0KDQo= --------------12xCtSQbtp4yc7Rc24L0mrKO-- --------------R9SsOEQ6L0oqBDiZjHUlzNm3 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYwfeEgUDAAAAAAAKCRCKV5yTsxlhuvvz AKDGd5dHUU2C1idWtIwlybXqEncr5ACfaEdSVQjG41ZMm8aZZtjbu31zZoA= =Xl/9 -----END PGP SIGNATURE----- --------------R9SsOEQ6L0oqBDiZjHUlzNm3--