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 1pd7tD-0006Xj-Rd for pgsql-general@arkaria.postgresql.org; Fri, 17 Mar 2023 11:04:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pd7tC-0002el-Dx for pgsql-general@arkaria.postgresql.org; Fri, 17 Mar 2023 11:04:50 +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 1pd7tB-0002eW-T8 for pgsql-general@lists.postgresql.org; Fri, 17 Mar 2023 11:04:50 +0000 Received: from mail-vi1eur04on2048.outbound.protection.outlook.com ([40.107.8.48] helo=EUR04-VI1-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 1pd7t8-0004x1-Kn for pgsql-general@postgresql.org; Fri, 17 Mar 2023 11:04:48 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=lCz6z+n3xEEb2T5U6piAmhVwo5bHWRku2mgepR69iyJvCpQpY47MqzRaodXVHiOzFGmVFV9NjmxCqtlb0sKYgRmwRCm6Cw/RxfVcpSWr/mk7ViOdr4+8MvS2yCt4TTE4D4/W1tSYce2Mnoz+pRR8y8JS/ZAilSyBmnqmSzUssyXrsrkzXcU6X4mj6gUQGb7OfkiOF9nqNdnP+Dh+6Ri6uZr2vCOE0NOjvInncmWN5TTMo89UeH44U8dYzXLRbkxt4u2KNcJ1RvTi1Xf2yTMJ8znvf4cfXBxLKmbRefWJUhl1B5XK42QSzpL/Lk9hC0t58ssgg1SCwudUAv3mXUEjvQ== 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=9tneixmPnBk8tPBmimfFAiwhJlkPNmWmCYHxRQzoJY4=; b=l2ehWUXBwSxysCJkVLAIT5RFXU1YjxlQ5ZWGdNqu2rJsbuSRimhUI14lovgvDtAipgRnteU0PFz4HpsltpYsHq0mIbPjROW9PccPL1ZmTWFoJFEeD7fZXGmhlw4S0Or4tfG2MRINwXPsgzLscSWqW1ygwobJaDr+xG3DkAG2ppYv5BilSPuezOUhEeXMUlkWLoratuLOXnCqnh4clgz0Hr8dR0IXuIhznDrYhKqJl0bkJV0rB9YkJyyAzsBtIoBCttB/RrzArYQrkCPb2wr5m66RKB9gQkKer91V0SMKDphI0yLNAom6fT1CQn6mQRTYzMkXqElJRtMeEGy1O9ltGQ== 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=9tneixmPnBk8tPBmimfFAiwhJlkPNmWmCYHxRQzoJY4=; b=Y9CVHcabBCCBnLKoTRjKZk3gFnqPYozHicIsE1GQbPX76i/0nhqJISkySnDiecA0jY6GdrqDBWht/qpqEePeeELOr95dnALRksFcX8/siTkhzFr1FXwivqW8OEP5bZbz5ONiNFxRRTROSebbN421fMxJi8idhUi7QWk+lfh9xWE= Received: from AM9P195MB0790.EURP195.PROD.OUTLOOK.COM (2603:10a6:20b:1ff::22) by GV1P195MB1713.EURP195.PROD.OUTLOOK.COM (2603:10a6:150:54::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6178.26; Fri, 17 Mar 2023 11:04:42 +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 11:04:42 +0000 From: Wim Bertels To: "shammat@gmx.net" , "pgsql-general@postgresql.org" Subject: Re: nested xml/json to table Thread-Topic: nested xml/json to table Thread-Index: AQHZWLf6k93mWHcixUqo4C/0Z3eJLq7+wwKAgAAMGgA= Date: Fri, 17 Mar 2023 11:04:42 +0000 Message-ID: <0d59af8d8b855c8f97796e611280b993ee261f7f.camel@ucll.be> References: <05b3f3beccba4ce16d2a4ad411085ae5c46e2e82.camel@ucll.be> <90741398-62ca-3bd5-79d0-c0f6a2eef4cf@gmx.net> In-Reply-To: <90741398-62ca-3bd5-79d0-c0f6a2eef4cf@gmx.net> 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_|GV1P195MB1713:EE_ x-ms-office365-filtering-correlation-id: ed4db264-fb55-4954-ee2c-08db26d7690a x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: pH1e3dJ9Rk7VjsNML0BnwWJlz0nvulp2E3+obsC3kfkUuD4zJEZ6F93kDmanfW2MQCg4mM0hZ76clk/8A4/84LH1XqnDZc5AjZARnlUDS0BNObA24Wi5apWVqXqFtRcyk7qgc0je5w7pUTADYODnnMjCmC8DtPLkE0TIH8G9bXTRA+QKASs04NOO8GjTp2Z1R7YfG1929zbynEywckcXYe+Ufo2fuyAtHY8XwRAC8TFtHE+0RAJ+5a+Oy96YGCipyMXNlWHjXZ+2+wbJxrCdp2wJ9cINrEKEU7pUvhEL8PKlO/cRz7Tz5Kiy/p95CAF36naEAS0vEXpAlwDjVIIbP1nfFr9Lu3Zr7cnOGMdzyD8ckLgPtzEgtHrkxNEOKsvgvgIW3v2x9+YZLEnimb6fWNXJDH0tP19mJTINaHGUJ6PctpCqt5iSAzyT1WT8euFadl6+qIk6bQr+oWzcm+Xsyfaaq0CXqRQcRyHqp3zSO77vDl+0ncmCZejuQDxeZc/OFxXd989K27wDRvmHRZDvTUg6BlC+xEE7J2U+MWsMwuoUQVoBXNaVwVRiZWEhkAuXLxzgbj2QjsPlaxA6wgCDaRwkvTkrHj7jhulpSf8xsnbLPLoIkU7dLH9ElouwAa9HWI0S7z2mwEveqQvOR7emNvNZAuBi5M+80/avG1W+RJobWtPFlNXECe5CYk0nWA3qRmNffCHG92SPbLdbsXMwcQ== 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)(376002)(136003)(39860400002)(396003)(366004)(451199018)(36756003)(5660300002)(4744005)(44832011)(2906002)(8936002)(41300700001)(38070700005)(3480700007)(86362001)(122000001)(38100700002)(41320700001)(76116006)(71200400001)(66946007)(66476007)(66556008)(6486002)(66446008)(64756008)(8676002)(786003)(316002)(478600001)(6512007)(186003)(2616005)(110136005)(6506007);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?WEFiTklvekd0OVBvUXVqamhSQWgzMTRtb2t1aVBPOEN4cSs5NEMxRXlXZE8w?= =?utf-8?B?a2M0NlRZZTlYZ2trTUpkQThOWkhEWXAwY0dRUDZaWE5kTGpUc2NiVWdHcUp6?= =?utf-8?B?cjFGWFRBL29sV05ud3VJTmFlNlRjMXdIY3ZSdHdBTk44b1djaTczcHNDaVdT?= =?utf-8?B?QkxuczNaaXN4YlV3ZSsrN1FLZUJ0RXFtVHlvNjBTMXZVQ3BnaWZlckl0VWkx?= =?utf-8?B?U2VuVzFlcTAvZytPazd6YjRGUy9lVCs4cGlRd3c4OEtwQzZrTWFTWndNeWVS?= =?utf-8?B?Q0s5RExONWJmTk81dG1rRW10NU1aeFNMbERyUUEvZlI4SmRwcGhLN1hkVXNi?= =?utf-8?B?S0NZZ3dNTGtySG5BOUZvT2FRbDk1a0UvOEs5V0lZZE4zSjJWWkoxaHVhTE9S?= =?utf-8?B?aVlkdUdlcFZsQlRRZWtqV3Y0SVBwVHdqS21aL1UySmhDMVFrNWZOTksxSEtv?= =?utf-8?B?UVBYNXVoZ3lrRXQrT2tWekxaQXFHTFQySm5CLzNCQStNSzd1cXFxaER1Z01N?= =?utf-8?B?K2s4Q05uY1lVM1orbVorZTdWQTVTUElWaXQxekEyaHlvRWF3VnFvZ3N4MTBj?= =?utf-8?B?cVlhOFhkVU9rbzFVRDVlNS9uZC9HVWsrcTJnOG81ckhMaDdCSUJDdTUraHZK?= =?utf-8?B?Qk9GZFZWai9UbEh5eXNWTW9leWdYUUJmSm5Gd3lFT1hrQi9Nci9PMnJrMTYy?= =?utf-8?B?bUhDVldxUUMzOGFUU2FTalBNeXlUZnpHZFdTWTRWczJ1WVlQNWpVdkVOeGJE?= =?utf-8?B?eHNVRldjTEFhb29mVlBrMWpEcDBTT1RxNGEzWE1semRINm13V1hHbVM2UkxF?= =?utf-8?B?cTF3YTNodFZZUWFCMFpLUVE3bFF3YnFKd2VtcnVUWWdxUHc1MjI1UXpsZzNJ?= =?utf-8?B?ZWx2ZVlTTEVrbVF5WFdXZ1ZZWDNHOHpOaGE4akhHWjZxaWp6YWhjL1E2VWxZ?= =?utf-8?B?YUw3Z2psNkFTU3FkNDUvMUh2UWZGOTloQ1F3a2pmYllLeXdwbUdIU3NDM2pZ?= =?utf-8?B?VlRLTk5uWXBpa1hvYXpmUXYwenhRUzNmcVRGSWVtYlkwb2EzdDJZdTlKeFc1?= =?utf-8?B?bURHelJWU0hzTXh6bm5RZUtva1oybXFHS3F4SVJCbk1hSDhFRUhmV1c5bW9T?= =?utf-8?B?NnJ5aitSdzAvelhPM2pBNitDSC9DNG9QM3RleGUxTFQ0dkhsNy9OMG1BS0tF?= =?utf-8?B?UHppcXllVDJ0Z3pSR0ZTOU83cGtNc2VQZERuQjAvSXBOM3dLVnhOb0JxVTRv?= =?utf-8?B?N2pSbnAyem4vUHFGSlYxUCtoTTQzS2Z1Q29YNzFEN1NhdCtpNk9KaEpPcXNL?= =?utf-8?B?ZGhPTENvOEJJWDkwSEQvWmtKQmZ6ZHYyVFlLZmY0eWpxUTI0bWV6Y29sTEZ1?= =?utf-8?B?QXlJOWsyc2poM1l4ZXRzQVNwckF6M1g1TDJLcDVRRWZTcXRFaVFIV1U1eVJo?= =?utf-8?B?QW1mWmpQODl6UThzUjhGQnA0OUJacHVFTElQckJTUXNsUkYvN1h2UkJYM1da?= =?utf-8?B?ck5ZODJSSTlxWWhVVG1tcldrT0VnNW03MURBWnV4OEN2N0FZWkU0U1I4RXdS?= =?utf-8?B?YXhwM3dRa0JVTzJiVXVoWmY4SFQxYzdmenc0R3YwM2RIQmhTRjIzSGFRMTlx?= =?utf-8?B?SmkyUi9yR1dhRTZBVnBEMldKeFZyWVZ0Y2VjTlR1eGpnaUd1WklsZUpqTkd2?= =?utf-8?B?NFk4dndNMURhcXduK3ZYRVA3U0dYa3V4ZTYwdnZXbldsWGl3NEtLVWd4WUJG?= =?utf-8?B?dzkxbk9rbEU0V0NTa0ZWcWhCRzNtVkgxSGJlNGRXMWdHZU5jK2hTYUNmWjdF?= =?utf-8?B?UmFlcmE4OFE2REhKSnVqT1RBek5DaXlnMW5Bc0ZWQVJwT2tCR1JCK1paajdS?= =?utf-8?B?WURBYklsRjhlRU4ycVl4ck1qb0dHREtDRkg4Y3ZLcllNai9YWjhHdTVQd0Vz?= =?utf-8?B?bXo4cTFTQnNqMnZ3c3B3dE5saS9iWVcrSDkxbTJEeFpyL2Z2ZTB3T3IyQlda?= =?utf-8?B?cXIzVDk4YTdMZnc2U1VOTStGc2ZmMUxVUEk0SnRSQ2JodlpFQm5EQXdMT25x?= =?utf-8?B?b1ZwL1g1V3QwTWlJNEV1TUtkdGh3ZWlobWVNV1FmZklSa21WSFJZNGtVbzh5?= =?utf-8?B?aWFHMUd2MExja25Va3ZkZTBqdDJRd25vQ2dpUEorMkxQNFlDVHlaVUxyV0RO?= =?utf-8?Q?FjchZ9LfJvrjpFQdxpoCUaXs5qXD8W/ru0Q598wDDkcG?= Content-Type: text/plain; charset="utf-8" Content-ID: <9652CCF6723E2343A8AC9D17E8B91369@EURP195.PROD.OUTLOOK.COM> 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: ed4db264-fb55-4954-ee2c-08db26d7690a X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Mar 2023 11:04:42.5049 (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: 0msiQx3sVk6e36cAHtDAM/I8mzeVM4AIPMj9sL9XCjqAShFtOyWr4f6GNFNxYfayhWXrTsLDRxFPiBX+8OVKHA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: GV1P195MB1713 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhvbWFzIEtlbGxlcmVyIHNjaHJlZWYgb3AgdnIgMTctMDMtMjAyMyBvbSAxMToyMSBbKzAxMDBd Og0KPiBXaW0gQmVydGVscyBzY2hyaWViIGFtIDE3LjAzLjIwMjMgdW0gMTE6MDU6DQo+ID4gd2hh dCB3b3VsZCBiZSB0aGUgZ2VuZXJhbCBpZGVhOiAiZWFzaWx5IiBjb252ZXJ0IGFuIGhpZXJhcmNo aWNhbA0KPiA+IHN0cnVjdHVyZSBsaWtlIGpzb24gb3IgeG1sIHRvIGEgdGFibGU7IGZvciBleGFt cGxlIGNyZWF0aW5nIGNvbHVtbnMNCj4gPiBieQ0KPiA+IGFwcGVuZGluZyB0aGUga2V5LW5hbWVz IHdoZW4gZ29pbmcgZG9pbmcgZG93biB0aGUgdGhyZWUsIHVzaW5nIG51bGwNCj4gPiBmb3INCj4g PiBlbXB0eSB2YWx1ZXMsIGFkZGluZyBtb3JlIGNvbHVtbnMgYXMgbmVlZGVkIGJ5IHRoZSBnaXZl biBzdHJ1Y3R1cmUuDQo+ID4gKDEtd2F5IG9wZXJhdGlvbikNCj4gDQo+IA0KPiBZb3UgY2FuJ3Qg aGF2ZSBhIGZ1bmN0aW9uIHRoYXQgcmV0dXJucyBhIGRpZmZlcmVudCBzZXQgb2YgY29sdW1ucw0K PiBlYWNoIHRpbWUgeW91IGNhbGwgaXQNCj4gKHdpdGhvdXQgc3BlY2lmeWluZyB0aGUgb3V0cHV0 IGNvbHVtbnMgLSB3aGljaCB5b3UgZG9uJ3Qgd2FudCkuDQoNCkhlbGxvIFRob21hcywNCg0KdGhh bmtzIGZvciB0aGUgZmVlZGJhY2ssDQppIHdhcyB3b25kZXJpbmcgaW4gdGhlIGxpa2VzIG9mIGV4 aXN0aW5nIGJ1aWx0LWluIGZ1bmN0aW9ucyBvcg0KZXh0ZW5zaW9ucyAobm90IENSRUFURSBGVU5D VElPTikNCg0KbXZnLA0KV2ltDQoNCg0K