Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iDTWC-0000xb-MR for pgsql-bugs@arkaria.postgresql.org; Thu, 26 Sep 2019 13:09:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iDTWB-0004Nu-74 for pgsql-bugs@arkaria.postgresql.org; Thu, 26 Sep 2019 13:09:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iDTWA-0004Nj-SI; Thu, 26 Sep 2019 13:09:11 +0000 Received: from mail-eopbgr80082.outbound.protection.outlook.com ([40.107.8.82] helo=EUR04-VI1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iDTW7-0001fc-9S; Thu, 26 Sep 2019 13:09:10 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=hegXAnSqzH1CEZYmEyUQMgl1IvnE6eQcwtv58WSx9zupfp869TF3cKtgjkSLpO+jw44+bM9haYNzgJX6sZEQW+6jS/udFh26ljaHiuzmH2Xl9sjpdUMU2r3QNwh6kTnvPPOXkVZ1cAcTSD1EY0J95jJaKiebzQIYrWK+e1Gx2Bp8LwaTiGf355/O2r9y9xD4DouB9/719R2+7tH2jJBJRFPidWZChIXnZK3FBF6ZDc53NdVk2zq5TePIHFR5pibX7/0UhEc5dhBeU7sJAP2ZdSIXy05NjPYRSgxWRUMGKw/2Dmz1OqA4jBellx97Hai1Ic5KGjh1W3Rc9/V2sJ/i2w== 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-SenderADCheck; bh=zga6pWVrtj7wj3fAcsvHQlGAlWNoDy6d8PNgKCf0oNc=; b=XKF9kfda4TEOkINbeeJcUMj6GfoCV+5WkaofI9eusnqM/7M0C5/Cb5IJYB5wri8Edg4VfxhzHDi1DKJfWbwVdqprtcAwJShTXeT8gn9x8bRBXu0Y5IlPhX5fyZjpnqDeFQ2MZDWjLf863VjQ9rYnkuyq/ER+o3mGGjnF2dOdb+to9XiwTbc20VFgghOMMH9+C4QZBCPa1IefxNI9Lk49PipwvyPT6IchahcSilGfVT9jESPtyvoLkBSVqgygokKo6ZQlboAHC9bsxQO19AvU61X3/RZ7nGaOo3nh7wnEpk1rbiHTWlKl3rnJGcxjhUOmqJ9qArqYqXTj88LMIfd+lg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=principiamentis.com; dmarc=pass action=none header.from=principiamentis.com; dkim=pass header.d=principiamentis.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=principiamentis.onmicrosoft.com; s=selector2-principiamentis-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=zga6pWVrtj7wj3fAcsvHQlGAlWNoDy6d8PNgKCf0oNc=; b=xaRrr1SCymnJlwP/bv0N9mfO77BwUtNt6lf+xMwhkVE0p8yp5BRzHfsRssFqHp8+Wu5YXcn5xkQFkTSsmZgzBEEvuzogUxcerAyVsAdhHrRsPj6LE93bNNi1+3uqXtFiqviUFQkwufQPelr2HQu+G7mT/kXxVMZCmqmDbCmc+dA= Received: from VI1PR0502MB4096.eurprd05.prod.outlook.com (52.134.19.21) by VI1PR0502MB3742.eurprd05.prod.outlook.com (52.134.8.153) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.2284.26; Thu, 26 Sep 2019 13:09:04 +0000 Received: from VI1PR0502MB4096.eurprd05.prod.outlook.com ([fe80::d99f:12f3:2a1a:dd1c]) by VI1PR0502MB4096.eurprd05.prod.outlook.com ([fe80::d99f:12f3:2a1a:dd1c%3]) with mapi id 15.20.2284.023; Thu, 26 Sep 2019 13:09:04 +0000 From: Andreas Bergmaier To: Tom Lane , "pgsql-docs@lists.postgresql.org" CC: "pgsql-bugs@lists.postgresql.org" Subject: Re: BUG #16022: to_json on arrays with unusual lower bound is not intuitive Thread-Topic: BUG #16022: to_json on arrays with unusual lower bound is not intuitive Thread-Index: AQHVc65WC7Dit9uTjE2eAC0baemsVqc978UA Date: Thu, 26 Sep 2019 13:09:03 +0000 Message-ID: References: <16022-5c864f8a572d5b5b@postgresql.org> <23022.1569422056@sss.pgh.pa.us> In-Reply-To: <23022.1569422056@sss.pgh.pa.us> Accept-Language: de-DE, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-clientproxiedby: AM3PR05CA0087.eurprd05.prod.outlook.com (2603:10a6:207:1::13) To VI1PR0502MB4096.eurprd05.prod.outlook.com (2603:10a6:803:26::21) authentication-results: spf=none (sender IP is ) smtp.mailfrom=ab@principiamentis.com; x-ms-exchange-messagesentrepresentingtype: 1 x-originating-ip: [93.104.93.138] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 45ddc2f9-9ce4-485e-3454-08d74282b46b x-microsoft-antispam: BCL:0;PCL:0;RULEID:(2390118)(7020095)(4652040)(7021145)(8989299)(4534185)(7022145)(4603075)(4627221)(201702281549075)(8990200)(7048125)(7024125)(7027125)(7023125)(5600167)(711020)(4605104)(1401327)(2017052603328)(7193020);SRVR:VI1PR0502MB3742; x-ms-traffictypediagnostic: VI1PR0502MB3742: x-ms-exchange-purlcount: 2 x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:9508; x-forefront-prvs: 0172F0EF77 x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(366004)(396003)(136003)(346002)(376002)(39830400003)(189003)(199004)(6486002)(2906002)(31696002)(8936002)(66066001)(31686004)(7736002)(229853002)(5660300002)(11346002)(446003)(25786009)(2616005)(71190400001)(86362001)(305945005)(64756008)(66946007)(66556008)(66476007)(66446008)(99286004)(14454004)(71200400001)(6116002)(102836004)(76176011)(4326008)(3846002)(6246003)(52116002)(476003)(81166006)(966005)(81156014)(6512007)(386003)(256004)(186003)(36756003)(2501003)(486006)(6306002)(26005)(110136005)(53546011)(316002)(8676002)(6506007)(6436002)(508600001);DIR:OUT;SFP:1101;SCL:1;SRVR:VI1PR0502MB3742;H:VI1PR0502MB4096.eurprd05.prod.outlook.com;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;MX:1;A:1; received-spf: None (protection.outlook.com: principiamentis.com does not designate permitted sender hosts) x-ms-exchange-senderadcheck: 1 x-microsoft-antispam-message-info: tikCcUTUKJ8UkM2625+wyb4R3cnZIAKfpHWDnkt2VM694i4EcvV1nchiMoF7fseN0F2zCjMAGLRlah66XuOp2DAwhr+L0ieoryvp6GnsZQ4gDBPoO36s/lfdUPzi7S5LTya6q7gBM6b1jZ2NT06pDm7z5fNxYNQuwb9dtduiAczSOvO5EPYpZZh6kDneb7e7S4/LRAI/rguYaJN+i0RaJqLeVBwvio6PPJ+q3ecitgOU380NSIPcI1FOVEoIVcCH0womy7aJ6sIsTGXWG18REzOUYyoks8PHA+R+8DrtMOYFKU6dp9nlhn2jsvhpLAOTamOf1d3cDETkd4MytJsIlUkbCwxkF4FriGZhBYyGGjWcaUCjYu9CFSMNE4HHi0I9TklKknwkjSd6/JS8vIUkwh0QlxbSRGa/hABdSuR9kYXDwpVmTb0B8cUFzg2uMDts9n9IJQnFdSWkTnjTNsQXow== x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: principiamentis.com X-MS-Exchange-CrossTenant-Network-Message-Id: 45ddc2f9-9ce4-485e-3454-08d74282b46b X-MS-Exchange-CrossTenant-originalarrivaltime: 26 Sep 2019 13:09:03.8229 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 2ce6ad70-a6cd-47d4-95fe-d50e9b7272df X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: Wb+8lvQcpcjA9ysaKiHEOlx+72uabE9ny9QQfbcOUVMtVbyVb3zrEQlpO0dZ0oxFkoY3H2otQcjedwElR2byDQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI1PR0502MB3742 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SGkhDQoNCk9uIDI1LjA5LjE5IDE2OjM0LCBUb20gTGFuZSB3cm90ZToNCj4gUEcgQnVnIHJlcG9y dGluZyBmb3JtIDxub3JlcGx5QHBvc3RncmVzcWwub3JnPiB3cml0ZXM6DQo+PiBJIHdvdWxkIGV4 cGVjdCB0aGUgYXJyYXkgaW5kaWNlcyBvZiBhIEpTT04gYXJyYXkgdG8gbWF0Y2ggd2l0aCB0aGUN Cj4+IHN1YnNjcmlwdHMgb2YgYSBwb3N0Z3JlcyBhcnJheSB3aGVuIGNvbnZlcnRpbmcgdGhlbSBi YWNrIGFuZCBmb3J0aC4NCj4+IEhvd2V2ZXIsIFBvc3RncmVzIGxldHMgdGhlIEpTT04gYXJyYXkg YmVnaW4gYXQgdGhlIGBsb3dlcl9ib3VuZGAgb2YgdGhlDQo+PiBhcnJheSwgbm90IGF0IHN1YnNj cmlwdCAxICg9IGluZGV4IDApLg0KPj4gRm9yIGV4YW1wbGUsIGB0b19qc29uKCdbLTI6NV09ey0y LC0xLDAsMSwyLDMsNCw1fSc6OmludFtdKWAgcmVzdWx0cyBpbg0KPj4gYFstMiwtMSwwLDEsMiwz LDQsNV1gIHdoZXJlIEkgd291bGQgaGF2ZSBleHBlY3RlZCBgWzEsMiwzLDQsNV1gIChvciBhbg0K Pj4gZXJyb3IsIHNpbmNlIEpTT04gYXJyYXlzIG11c3Qgbm90IGhhdmUgbmVnYXRpdmUgaW5kaWNl cykuDQo+IA0KPiBJIGNhbiBzZWUgbm8gcmVhc29uIHdoYXRldmVyIGZvciBlaXRoZXIgb2YgdGhv c2UgZGVmaW5pdGlvbnMgdG8gYmUNCj4gYmV0dGVyIHRoYW4gdGhlIGVzdGFibGlzaGVkIG9uZS4g IElmIHlvdSB3YW50IHNvbWUgb3RoZXIgY29udmVyc2lvbg0KPiBydWxlLCB3cml0ZSB5b3VyIG93 biBmdW5jdGlvbiB0aGF0IGJlaGF2ZXMgdGhlIHdheSB5b3Ugd2FudC4NCg0KT0ssIEkgYWdyZWUg aXQncyBraW5kYSB1bnJlYXNvbmFibGUgdG8gY2hhbmdlIHRoaXMuDQoNCkhvd2V2ZXIsIEkgd291 bGQgbGlrZSB0byBzZWUgdGhpcyBiZWhhdmlvdXIgZG9jdW1lbnRlZCBhdCANCmh0dHBzOi8vd3d3 LnBvc3RncmVzcWwub3JnL2RvY3MvY3VycmVudC9mdW5jdGlvbnMtanNvbi5odG1sLCBzbyBGVVAn ZCB0byANCnBnc3FsLWRvY3MuDQoNCkkgcHJvcG9zZSB0byBhZGQgdGhlIGZvbGxvd2luZyBkZXNj cmlwdGlvbiB0byBUYWJsZSA5LjQ1Og0KDQp8IFRoZSByZXN1bHRpbmcgSlNPTiBhcnJheSBzdGFy dHMgYXQgdGhlIGxvd2VyIGJvdW5kIG9mIHRoZSBQb3N0Z3JlU1FMIA0KYXJyYXksIHJlZ2FyZGxl c3Mgd2hldGhlciB0aGF0IGlzIDEgb3Igbm90Lg0KDQpNYXliZSBhbHNvIGFkZCBgdG9fanNvbign WzM6OF09ezMsNCw1LDYsNyw4fSc6OmludFtdKWAgYmVjb21pbmcgDQpgWzMsNCw1LDYsNyw4XWAg dG8gdGhlIGV4YW1wbGVzLg0KDQpXaGlsZSB3ZSdyZSBhdCBpdCwgSSB3b3VsZCBhbHNvIGxpa2Ug dG8gc2VlIHRoZSBkb2N1bWVudGF0aW9uIG9mIA0KYGFycmF5X2xvd2VyYCBhbmQgYGFycmF5X3Vw cGVyYCB0byBiZSBpbXByb3ZlZCBpbiANCmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3Mv Y3VycmVudC9mdW5jdGlvbnMtYXJyYXkuaHRtbC4gSSB3YXMgYSANCmJpdCBzdXJwcmlzZWQgdGhh dCB3aGVuIHBhc3NpbmcgYW4gZW1wdHkgYXJyYXksIHRoZXkgZGlkIHJldHVybiBgTlVMTGAgDQpp bnN0ZWFkIG9mIHRoZSAiZGVmYXVsdCIgdmFsdWUgYDFgLiBDYW4geW91IGFkZCB0aGF0IGFzIGFu IGV4YW1wbGUgdG8gDQp0aGUgdHdvIHRhYmxlIHJvd3MsIG9yIGp1c3QgYWRkIGEgc2ltcGxlICIo TlVMTCBpZiBlbXB0eSkiIHBhcmVudGhldGljYWwgDQp0byB0aGVpciBkZXNjcmlwdGlvbnM/DQpB bHRlcm5hdGl2ZWx5LCBkb2N1bWVudCBpdCBhZnRlciB0aGUgdGFibGU6DQoNCnwgSW4gYGFycmF5 X2xvd2VyYCBhbmQgYGFycmF5X3VwcGVyYCwgYE5VTExgIGlzIHJldHVybmVkIGlmIHRoZSBhcnJh eSANCmRpbWVuc2lvbiBkb2VzIG5vdCBleGlzdCBvciBpcyBlbXB0eS4NCg0Ka2luZCByZWdhcmRz LA0KICBBbmRyZWFzIEJlcmdtYWllcg0K