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 1pd6xj-0003HI-Ma for pgsql-general@arkaria.postgresql.org; Fri, 17 Mar 2023 10:05:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pd6xi-0001xw-HP for pgsql-general@arkaria.postgresql.org; Fri, 17 Mar 2023 10:05:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pd6xh-0001xe-TJ for pgsql-general@lists.postgresql.org; Fri, 17 Mar 2023 10:05:26 +0000 Received: from mail-db5eur01on2087.outbound.protection.outlook.com ([40.107.15.87] helo=EUR01-DB5-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pd6xd-0004R7-JT for pgsql-general@postgresql.org; Fri, 17 Mar 2023 10:05:24 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=SOMl+bkv1Pinu2dedfJP8Pyj6fAGH5+p8I4uw8RZ6jSsU4Xa7ob/MzXaerdFrDVqnu9LpfDPKVErC/+GZ6BF33gZSD0tNTy4E9XTDz5Sg0IRflc6q9kXZytEfAOCizqHru1dEH0kiOxA+z00maDyh4TylswMRkWIqSuvf0clZ6DU2FqjQdyFTLDtIVFevp9mN4+sBjKlMo3kaDEJPuWAjzO6DPAZT/Pg2jFhJHYeA/ZYX6CMy1RH3WWry5hb7AXTaR7Sb3aFB1y/0+pAlDm/lyCKgo4QAiHBLKVZIEH7p0pMcjfVkyhPsdGEMlGI1JPbBadZlAcZqH8X52lzzLYSgA== 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-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=MsLLxsbMRA+EazcIzHsihanww6JmnULJ9gIUUdpNHC0=; b=nEz4+HK03Go4sKg2RfUqjNwM1dehC4N4iREn8zQ8IQQwJ0JxjmqCaUI7fWCnvXvqzq/ElLUa2TpVoUaY/FjioDmWWHmRfa6gAvQg4Czyo6yD8/F+PWafJcE+8QyQIIkER7ruqACQnkouNQakq2Mxm+/vkO0UsqcUsWxSzuMhoXSRmPQdWbs06FMUKxkWBaiTYq3mzk6vhnclFnR87czWMO56+X6SO67mLWpSm7MP8RIuip11muOeBI5rA52SQZvcalk7Xh4Vn3uuQ5lB70cOqcJlSlP0TWBzUrFV7IPJsafuLxyvxlKZm/irh89cYHmlLoeLnYmc6UFtnSp58fT3Qg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ucll.be; dmarc=pass action=none header.from=ucll.be; dkim=pass header.d=ucll.be; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucll.be; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=MsLLxsbMRA+EazcIzHsihanww6JmnULJ9gIUUdpNHC0=; b=M/JZx40PHIbn3KY6eU+llotHqLsXsi+yPLafy9J+F21wV2vL4cc5bGlQyQjeKONqXivn+EAn1DZjYRvvVh9O78De6U1ypQGeNPtVNdSaLyrBUea8zwK5UtEd/tHxCWi+j2YNv7ytvxQGjeAxAV4G/Wd1yUFlgNl164Kl5OCi4zc= Received: from AM9P195MB0790.EURP195.PROD.OUTLOOK.COM (2603:10a6:20b:1ff::22) by AS1P195MB1593.EURP195.PROD.OUTLOOK.COM (2603:10a6:20b:4af::13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6178.31; Fri, 17 Mar 2023 10:05:18 +0000 Received: from AM9P195MB0790.EURP195.PROD.OUTLOOK.COM ([fe80::fb99:81ca:8464:f74f]) by AM9P195MB0790.EURP195.PROD.OUTLOOK.COM ([fe80::fb99:81ca:8464:f74f%9]) with mapi id 15.20.6178.035; Fri, 17 Mar 2023 10:05:18 +0000 From: Wim Bertels To: "pgsql-general@postgresql.org" Subject: nested xml/json to table Thread-Topic: nested xml/json to table Thread-Index: AQHZWLf6k93mWHcixUqo4C/0Z3eJLg== Date: Fri, 17 Mar 2023 10:05:18 +0000 Message-ID: <05b3f3beccba4ce16d2a4ad411085ae5c46e2e82.camel@ucll.be> Accept-Language: nl-NL, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Evolution 3.38.3-1+deb11u1 authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=ucll.be; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: AM9P195MB0790:EE_|AS1P195MB1593:EE_ x-ms-office365-filtering-correlation-id: 89210a32-9d2d-4b4d-862d-08db26cf1c9c x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: WENaBxUPfm7ot8HW6sqx7hls2kIROjRuEVU+5+Hv81HpNTaDfIk8QlaF5uj4LIM1qY3cGM3k1D2eB2RYHwKzV73BtOTdfIa8atuP1JEa68rklMuLBUZksggBj0jk3KPwpCog3hfIFv52e+ZRyGDvitf7bjOZBZqAnQixcM5IHUcFjCDYGzrctxtmNBH5oGD1o/2fgSNHxDU5YiZbtsrqU9WCy5f+/P+q+7099+4CxYL0u4TcD5JgAVDB4XRu3TAJbCPwoHiEHiQzfY4wDF+lidl9oQQNLieE67vdyGAXc644sES+BkmIKcynVFmqKZUxbfilNDwnZoY/MSUXcFSGV+Z66ABx72eVkGjeOObugznRObN5kSqKiuijQAF0R3NzCgxqzWC4Vxc6lFC/d5Y7eEFeuxlWe2T5NpY2+doY4BUoqyV3UvMb8dIP1FGzCl6/UEQOYL+ZD24Te/Vf1vsg/nSOS+IOnWCsBkeQR04FkZnXj0OW6ngU0ZKU5DPH9V8edYBemlYfgu+BlmwgAL9DytgMzc/SqYIfuj8K5Yz5VDSiD1+OkaON2Q1vT3k6bo50jvWR9PtPeVRmW//yXZgz6vSKjciLGDqWnPiMH1+rMgz5P+FuYsvOTUmmb4Pl2YL8ckb1npz/r5W+ZUqVk7iWI5Wrn6tRz3H5ICEapdyfLUOAFU6nBB+ndEUBBj2FlqEPuodI8LnxzeWy8WAFzOborw== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AM9P195MB0790.EURP195.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230025)(4636009)(346002)(136003)(376002)(396003)(366004)(39860400002)(451199018)(6916009)(186003)(6486002)(71200400001)(2616005)(478600001)(6506007)(6512007)(786003)(316002)(66476007)(64756008)(66946007)(66446008)(76116006)(41300700001)(66556008)(8676002)(8936002)(2906002)(3480700007)(44832011)(5660300002)(36756003)(38100700002)(86362001)(41320700001)(122000001)(38070700005);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?MzViUm1EaEZrbExrT3E3WVIyRE9sejVrYzNlbmp5S1paS0V5ZElPVEZJRTdo?= =?utf-8?B?eERNVEVZNXpwanR6eEltcnEwY2l1cW5nNGJXWDIxb2ZNVmoxZEl1UG9rRmZh?= =?utf-8?B?VEVpYUI1T0RsajFQYkRNS0FZRXhML2tmbW1SeU9aT0dub09RempYNnNSMnlM?= =?utf-8?B?YSt0eFVHNkNYeXc2eUVMUk5TbDBsb2U0VzNESmNpOE9JeEF6R1RlUlczQUgx?= =?utf-8?B?dGVGMUI1a2FuTGdUalRvTHRLS09NUjVmRUdGRE5jN1pZcmplZ1JrUUtiMFRn?= =?utf-8?B?bk4zMzZXakZ1TkVkWFVQVkVLR2RGdlFwRVMzTGx0YnZpcHZlUTRRa2Q5N3Nn?= =?utf-8?B?dFhpeTRTQW1WdzZsSzlNdjZMOGlWa0VRREx5M3pkNW8zMWFPVTNDdG5TUllB?= =?utf-8?B?R2RWa09wR1Y3MlhDUEdUNWdxbS8yZUM0VTdJWmhQb29pcksxZ01KV0xpbjR6?= =?utf-8?B?dk42NUpIMmtoQ3NKTVB6ZnMwSFdtK3lzMSt3RTVOQWkyRERncmxRdkR2ZkxI?= =?utf-8?B?U2V0MEZLMWh2WDBhc3czMExoNlk3ZmtRVHpZR3Q0UzhUbXlmSk80cEpGRWNL?= =?utf-8?B?UmlRbElNM0hlNVJCNDViMUJNYU9zeldITUdySmJRN24wWkZmZ21JWWtZdUov?= =?utf-8?B?bjRLb0JuZXhvS1lnaTN0MVhQU0hKQi9XTHFGRHU2VVl1d3lwcktXK3I1NERu?= =?utf-8?B?QmdNT2s1REJzaXorb2hsQ0NCSW5BYkRkMFlzZGJFbEZwMHZQRTQxRXNXRGwr?= =?utf-8?B?ZjUvTWFZTHFnVk5LY0JtZlRFRG1wSmp0M3d3dE16enc0UEZFNXhzYnpLUFlq?= =?utf-8?B?c29uYjZMVXFxbmtuZkJTeGYwa2JZb0FaalJjMEVpUFJITThyRVYzUnc0Rmgw?= =?utf-8?B?eGgxNHBZTDVjS1VLUVg5RU0yQmZ3bkZwajFiZzVERzZrRDNudTFkd2tnN28v?= =?utf-8?B?Y29hM2dubzUyY0VFUytTV3dZcEtkdkxlQThCb0xkSVBxZzZjZ1d5Zm5ndWh6?= =?utf-8?B?TzdyY0lkYnFPVlpqaGlKTVIyejg4QUMwdnNvOEdPZlRHcHFkWjN6WjUyczBK?= =?utf-8?B?U1JETElXTVc2RHRTUmJsTUVEWnRwSEJiZEVsMFVBTzIzVWNzRk14Z3lRRk1x?= =?utf-8?B?T2poMGV4NWdSWWtSaHFoc0hmK2lyRjU4T3dTUU04Q2FodTBWeHlyWENBc1Zo?= =?utf-8?B?OHE1NkFTckx3dGJxdkp3RFd2dW5UZ21HTGhpVUZhdDJvNXRvZmloVWhUbGx6?= =?utf-8?B?ZzdESkZGVXBrYW80YWIvaEJIbzBlQWh4alRnY3FzZDZlMnB4NTBoakMyK2V5?= =?utf-8?B?M09JWWRJZmk0amVURTRtRGxLSUpjS3ZtYVp0TWppenA1NnhWRWllYzhOMDhx?= =?utf-8?B?YmE1aEk0ZDQ0Z0h6bi9IUzRzQVNQRWRBNkVKTWk5cksvWVI3M2dFR3J1UUdx?= =?utf-8?B?dUtua2QyU3RIUFk0WXNUd0U4b084NHcxRW9UZXpGY0d5SkdMVlYwOUdrWlJh?= =?utf-8?B?RzBQTzV3T1g5WlFsSGgxbktIWjYvZVF3azhvRjFFcVBkMUxwK21Ja0VIT2V5?= =?utf-8?B?UWtZN0V0Rkg2djUxUnVXWkFZU3plRVFGa0FCclByWVdIR0YxT3EzYVZpMEZE?= =?utf-8?B?L05yOWV0VTFnSERRd3ExMThiNllRRnRSelU1TnRTZVR6TmtYcjIxcWN3cGpj?= =?utf-8?B?NmdrRXV0UzFMSCtCelUvVC90bDVCWHFnQWJCN1k3UE10Sk5DMHVwNzBkMEJL?= =?utf-8?B?NmpJOTVub0N6T0taQ1dWTzlETTVvajZnWk43aHJKM0JBbm51dGd5VFhUVmdW?= =?utf-8?B?dU90K3I5RmlrNUoyL015eW1jK3hHVm91TDVJUGtOM1N5RlJtaERWa0hSYkk1?= =?utf-8?B?Tm85VnRtQXB6MGYvMkk0YlRnL3B4US9Ta2V4YVR6UVNrb1NZc0pJSVdIZFNB?= =?utf-8?B?NS8vUzRuaVkybVZOVFZybFZRL1dVMmtvdGZ0M2VpMWkwVEk0T3RUWnNxL1E0?= =?utf-8?B?S3BLR1QwbWxRQlArVm4vYWsyL25tSFZrMEJwWEg3Z1RTZ1JwTmVpa3g4eThJ?= =?utf-8?B?U3ZubGtQVWZYbnFmMUZES0NheVlydTg2TU1TNEV4QVhiZE4rc3RsbE9mM3lp?= =?utf-8?B?RnlHTmhPZDVqSlNEUGd2a245ZzlTL25kSTkwV09Od2ViV0JEUkRmWkpnNnJB?= =?utf-8?Q?jzuEkk35rYVfktwBshwr2ToJUL4Aeng4x8r7BbNv3nGV?= Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: ucll.be X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AM9P195MB0790.EURP195.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 89210a32-9d2d-4b4d-862d-08db26cf1c9c X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Mar 2023 10:05:18.2694 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: e638861b-15d9-4de6-a65d-b48789ae1f08 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: nzLVkkEZKDJmWbRabNsOwIWbzhd7iRJX93w5QaUNb2mGp6xbHBmwFkqT+CbCKSTHCLLXMhjAT9VjFouoHNFaGw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS1P195MB1593 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGVsbG8sDQoNCmluIHB5dGhvbiBwYW5kYXMgdGhlcmUgaXMgZm9yIGV4YW1wbGUgYSBqc29uX25v cm1hbGl6ZSBmdW5jdGlvbiwNCmkgZGlkbid0IGZpbmQgc29tZXRoaW5nIHNpbWlsYXIgb3IgYmV0 dGVyIGluIHBvc3RncmVzcWw/DQoNCndoYXQgd291bGQgYmUgdGhlIGdlbmVyYWwgaWRlYTogImVh c2lseSIgY29udmVydCBhbiBoaWVyYXJjaGljYWwNCnN0cnVjdHVyZSBsaWtlIGpzb24gb3IgeG1s IHRvIGEgdGFibGU7IGZvciBleGFtcGxlIGNyZWF0aW5nIGNvbHVtbnMgYnkNCmFwcGVuZGluZyB0 aGUga2V5LW5hbWVzIHdoZW4gZ29pbmcgZG9pbmcgZG93biB0aGUgdGhyZWUsIHVzaW5nIG51bGwg Zm9yDQplbXB0eSB2YWx1ZXMsIGFkZGluZyBtb3JlIGNvbHVtbnMgYXMgbmVlZGVkIGJ5IHRoZSBn aXZlbiBzdHJ1Y3R1cmUuDQooMS13YXkgb3BlcmF0aW9uKQ0KDQphIGZldyBjb25jZXB0dWFsIGdp c3RzOg0KanNvblg9DQp7DQogICAgImdsb3NzYXJ5Ijogew0KICAgICAgICAidGl0bGUiOiAiZXhh bXBsZSBnbG9zc2FyeSIsDQoJCSJHbG9zc0RpdiI6IHsNCiAgICAgICAgICAgICJ0aXRsZSI6ICJT IiwNCgkJCSJHbG9zc0xpc3QiOiB7DQogICAgICAgICAgICAgICAgIkdsb3NzRW50cnkiOiB7DQog ICAgICAgICAgICAgICAgICAgIAkJCSJJRCI6ICJTR01MIiwNCgkJCQkJIlNvcnRBcyI6ICJTR01M IiwNCgkJCQkJIkdsb3NzVGVybSI6ICJTdGEuLiI7IA0KCQkJCQkiQWNyb255bSI6ICJTR01MIiwN CgkJCQkJIkFiYnJldiI6ICJJU08gODg3OToxOTg2IiwNCgkJCQkJIkdsb3NzRGVmIjogew0KCQkJ ICAgICAgICAgICAgICAgICAgICAgICAgInBhcmEiOiAiQSBtZXRhLW0uLiIsDQoJCQkJCQkiR2xv c3NTZWVBbHNvIjrCoA0KCQkJCQkJCVsiR01MIiwgIlhNTCJdDQogICAgICAgICAgICAgICAgICAg IAkJCX0sDQoJCQkJCSJHbG9zc1NlZSI6ICJtYXJrdXAiDQogICAgICAgICAgICAgICAgfQ0KICAg ICAgICAgICAgfQ0KICAgICAgICB9DQogICAgfQ0KfQ0KDQpzZWxlY3QgKg0KZnJvbSBqc29uX3Rv X3RhYmxlKCdqc29uWCcpOw0KLS0gZ2VuZXJhdGVkIGNvbHVtbnMgd2l0aCBubyBkYXRhL29ubHkg bnVsbHMgY291bGQgYmUgcmVtb3ZlZC4uDQotLSBhcnJheXMgY291bGQgYmUgdW5uZXN0ZWQgaW4g dGhlIHByb2Nlc3MgYXMgd2VsbA0KDQpnbG9zc2FyeSB8IGdsb3NzYXJ5LnRpdGxlICAgfCBnbG9z c2FyeS50aXRsZS5HbG9zc0Rpdi50aXRsZSB8IC4uIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KbnVsbAkgfCBleGFtcGxlIGds b3NzYXJ5IHwgUwkJCSAgICAgICAgICAgIHwNCi4uDQoNCnRoZSBsYXN0IGNvbHVtbjogZ2xvc3Nh cnkudGl0bGUuR2xvc3NEaXYuR2xvc3NMaXN0Lkdsb3NzRW50cnkuR2xvc3NTZWUNCndpdGggdmFs dWUgIm1hcmt1cCINCg0KLS0tDQoNCndoYXQgaWYgdGhlcmUgYXJlIGRpZmZlcmVudCBzdHJ1Y3R1 cmVzIHRoYXQgbmVlZCB0byBiZSBjb21iaW5lZD8NCih0aGV5IGNvdWxkIGJlIGFkZGVkIGluIHRo ZSBzYW1lIG1hbm5lciBhcyBiZWZvcmUpDQoNCmpzb25ZPQ0Kew0KczE6W3sNCiAgICAiZjEiOiAi YSIsDQogICAgImYyIjogImIiLA0KICAgICJmMyI6IHsgImYzLjEiOiAiYyIsDQoJICAgICJmMy4y IjogImQifQ0KICAgfSwNCiAgIHsgDQogICAgImYxIjogImUiLA0KICAgICJmNCI6ICJnIg0KICAg fQ0KICAgXQ0KfQ0KICAgICAgICAgICANCnNlbGVjdCAqDQpmcm9tIGpzb25fdG9fdGFibGUoJ2pz b25ZJyk7DQotLSBnZW5lcmF0ZWQgY29sdW1ucyB3aXRoIG5vIGRhdGEvb25seSBudWxscyBjb3Vs ZCBiZSByZW1vdmVkLi4NCi0tIHNlcGFyYXRvciBzaWduIGlzIHVudHJ1c3RlZA0KDQpzMSAgfCBz MS5mMSB8IHMxLmYyIHwgczEuZjMgfCBzMS5mMy5mMy4xIHwgczEuZjMuZjMuMiB8IHMxLmY0DQot LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tDQpudWxsfCBhICAgICB8IGIgICAgIHwgbnVsbCAgfCBjICAgICAgICAgIHwgZCAgICAgICAg ICB8IG51bGwNCm51bGx8IGUgICAgIHwgbnVsbCAgfCBudWxsICB8IG51bGwgICAgICAgfCBudWxs ICAgICAgIHwgZw0KDQoNCmFueSBpZGVhcyBvciBzdWdnZXN0aW9ucyAoYXBhcnQgZnJvbSBwbHB5 dGhvbik/IA0KV2ltIA0K