Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1eQvzr-0003pa-88
	for pgsql-sql@arkaria.postgresql.org; Mon, 18 Dec 2017 14:02:23 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1eQvzq-00038O-Du
	for pgsql-sql@arkaria.postgresql.org; Mon, 18 Dec 2017 14:02:22 +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_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <lutz.horn@posteo.de>)
	id 1eQvzq-00038F-4n
	for pgsql-sql@lists.postgresql.org; Mon, 18 Dec 2017 14:02:22 +0000
Received: from mout01.posteo.de ([185.67.36.65])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <lutz.horn@posteo.de>)
	id 1eQvzn-0000KB-7v
	for pgsql-sql@lists.postgresql.org; Mon, 18 Dec 2017 14:02:21 +0000
Received: from submission (posteo.de [89.146.220.130])
	by mout01.posteo.de (Postfix) with ESMTPS id 67B4520F5C
	for <pgsql-sql@lists.postgresql.org>; Mon, 18 Dec 2017 15:02:17 +0100 (CET)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.de; s=2017;
	t=1513605737; bh=cCcAnw8/YXr94miMm2hpzUanGCWjR1kVG+lRZOpKSyo=;
	h=Date:From:To:Subject:From;
	b=LQQdxuipbPYQcGAni71D8BaCPiWFYyNwKF5PbjDcKuK/e85ioQKCxWnDP9HbnYYku
	 Wgfucrd7Lt3B7uSa7rQidbNludoqaX5zViKIHqMYACc/sM0rWzO32Wnuvhhu2hGed+
	 NuaHmV2iEG9OWS3aL0nzpVVw6K8Vd0Mf01ICFDjBgLJUPxKMWhFOOj6AY1936oEVwi
	 zNa7dvvTYD+CM27OU+2nAREQdsqHS3/7mEyJf1cxBDLpXNU99sFO8jqwpAKBZX78Bd
	 uBv0wmaPWY82N5C6d7hZnf3FuRwGpaczn7be0XXcKt3gTpJ0tKtPdXNCtz5OxaIfCc
	 JYqfAVOGmCq9Q==
Received: from customer (localhost [127.0.0.1])
	by submission (posteo.de) with ESMTPSA id 3z0jQZ005rz9rxF
	for <pgsql-sql@lists.postgresql.org>; Mon, 18 Dec 2017 15:02:13 +0100 (CET)
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII;
 format=flowed
Content-Transfer-Encoding: 7bit
Date: Mon, 18 Dec 2017 15:02:12 +0100
From: Lutz Horn <lutz.horn@posteo.de>
To: pgsql-sql@lists.postgresql.org
Subject: Re: XML Parsing in Postgresql
In-Reply-To: 
 <KL1PR04MB0999C40AC345478A1406D87FD80E0@KL1PR04MB0999.apcprd04.prod.outlook.com>
References: 
 <KL1PR04MB0999C40AC345478A1406D87FD80E0@KL1PR04MB0999.apcprd04.prod.outlook.com>
Message-ID: <dc64e5f915462cfe0cdbf3c332fc4728@posteo.de>
X-Sender: lutz.horn@posteo.de
User-Agent: Posteo Webmail
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Precedence: bulk

> PLEASE LET ME KNOW THE CORRESPONDING PARSING QUERY IN POSTGRESQL.

Take a look at 
https://www.postgresql.org/docs/current/static/functions-xml.html#FUNCTIONS-XML-PROCESSING

Regards

Lutz