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 1iD6L7-00051c-Mc for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Sep 2019 12:24:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iD6L6-0003yA-DB for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Sep 2019 12:24:12 +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 1iD6L6-0003uy-40 for pgsql-bugs@lists.postgresql.org; Wed, 25 Sep 2019 12:24:12 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iD6Ky-00041y-QL for pgsql-bugs@lists.postgresql.org; Wed, 25 Sep 2019 12:24:11 +0000 Content-Type: multipart/mixed; boundary="===============0193551127359674100==" MIME-Version: 1.0 Subject: BUG #16022: to_json on arrays with unusual lower bound is not intuitive To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ab@principiamentis.com Reply-To: ab@principiamentis.com, pgsql-bugs@lists.postgresql.org Date: Wed, 25 Sep 2019 12:23:11 +0000 Message-ID: <16022-5c864f8a572d5b5b@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0193551127359674100== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjAyMgpMb2dnZWQgYnk6ICAgICAgICAgIEEgQmVyZ21haWVyCkVtYWls IGFkZHJlc3M6ICAgICAgYWJAcHJpbmNpcGlhbWVudGlzLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDExLjUKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUKRGVzY3JpcHRpb246ICAgICAgICAKCkhp IQ0KSSB3b3VsZCBleHBlY3QgdGhlIGFycmF5IGluZGljZXMgb2YgYSBKU09OIGFycmF5IHRvIG1h dGNoIHdpdGggdGhlCnN1YnNjcmlwdHMgb2YgYSBwb3N0Z3JlcyBhcnJheSB3aGVuIGNvbnZlcnRp bmcgdGhlbSBiYWNrIGFuZCBmb3J0aC4NCkhvd2V2ZXIsIFBvc3RncmVzIGxldHMgdGhlIEpTT04g YXJyYXkgYmVnaW4gYXQgdGhlIGBsb3dlcl9ib3VuZGAgb2YgdGhlCmFycmF5LCBub3QgYXQgc3Vi c2NyaXB0IDEgKD0gaW5kZXggMCkuDQpGb3IgZXhhbXBsZSwgYHRvX2pzb24oJ1stMjo1XT17LTIs LTEsMCwxLDIsMyw0LDV9Jzo6aW50W10pYCByZXN1bHRzIGluCmBbLTIsLTEsMCwxLDIsMyw0LDVd YCB3aGVyZSBJIHdvdWxkIGhhdmUgZXhwZWN0ZWQgYFsxLDIsMyw0LDVdYCAob3IgYW4KZXJyb3Is IHNpbmNlIEpTT04gYXJyYXlzIG11c3Qgbm90IGhhdmUgbmVnYXRpdmUgaW5kaWNlcykuDQpBbmQg bW9yZSBhbm5veWluZ2x5LCBgdG9fanNvbignWzM6OF09ezMsNCw1LDYsNyw4fSc6OmludFtdKWAg cmVzdWx0cyBpbgpgWzMsNCw1LDYsNyw4XWAgd2hlcmUgSSB3b3VsZCBoYXZlIG5lZWRlZCBgW251 bGwsbnVsbCwzLDQsNSw2LDcsOF1gLg0KKFNlZSBhbHNvIHNvbWUgZGVtbwpodHRwczovL2RiZmlk ZGxlLnVrLz9yZGJtcz1wb3N0Z3Jlc18xMSZmaWRkbGU9MmQzNTk2MDg4MTVmNzA1OWYzMTIwZmEx N2RhMWJkZWYpDQoNCkp1c3QgZm9yIHJlZmVyZW5jZSwgSSdtIG9uIFBvc3RncmVTUUwgMTEuNCAo RGViaWFuIDExLjQtMS5wZ2RnOTArMSkgb24KeDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQg YnkgZ2NjIChEZWJpYW4gNi4zLjAtMTgrZGViOXUxKSA2LjMuMAoyMDE3MDUxNiwgNjQtYml0LCBi dXQgSSBkb3VidCBpdCBtYXR0ZXJzLg0KDQpJIGNhbiBjaXJjdW12ZW50IHRoaXMgYmVoYXZpb3Vy IGJ5IHVzaW5nIGEgZnVuY3Rpb24gbGlrZQ0KQ1JFQVRFIEZVTkNUSU9OIGFycmF5X2ZpbGx1cChh cnIgYW55YXJyYXkpIFJFVFVSTlMgYW55YXJyYXkNCkFTICQkDQpCRUdJTg0KICAgSUYgYXJyYXlf bG93ZXIoYXJyLCAxKSA+IDEgVEhFTg0KICAgICAgIGFyclsxXSA9IE5VTEw7DQogICBFTkQgSUY7 DQogICBSRVRVUk4gYXJyOw0KRU5EDQokJCBMQU5HVUFHRSBwbHBnc3FsIFNUUklDVDsNCmJlZm9y ZSBwYXNzaW5nIG15IHNwYXJzZSBhcnJheSBpbnRvIGB0b19qc29uYCwgYnV0IEkgd291bGQgbGlr ZSB0byBrbm93CndoZXRoZXIgdGhlcmUncyBhIGJldHRlciBzb2x1dGlvbiBvciB3aGV0aGVyIHRo ZSBpc3N1ZSBjb3VsZCBiZSBmaXhlZCBhdCB0aGUKY29yZS4gKFByZXN1bWFibGUsIGJyZWFraW5n IGJhY2t3YXJkcy1jb21wYXRpYmlsaXR5IGlzIGEgcHJvYmxlbT8pDQoNCktpbmQgcmVnYXJkcywN CiBBbmRyZWFzIEJlcmdtYWllcgoK --===============0193551127359674100==--