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 1gziJO-00053M-Ry for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Mar 2019 13:34:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gziJN-00047z-JU for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Mar 2019 13:34:49 +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 1gziJM-0003y1-VD for pgsql-hackers@lists.postgresql.org; Fri, 01 Mar 2019 13:34:49 +0000 Received: from anastigmatix.net ([68.171.219.55]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gziJI-0004sx-TQ for pgsql-hackers@postgresql.org; Fri, 01 Mar 2019 13:34:48 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=anastigmatix.net; s=default; h=Content-Transfer-Encoding:Content-Type: In-Reply-To:MIME-Version:Date:Message-ID:From:Cc:References:To:Subject:Sender :Reply-To:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=cr58X2iVZa7V43pVEkdGrnV1dXOZz6uWAjuJoxHxQ7Q=; b=KkXmIYEPQ/ZKYvQE/A1VCpJ6Jo F8NEpteTuZIurXgnux41UCsHBnx85dpiLmDewoHe554bNTULc8F0a9bj9xQl+aiLPMv0Pgw3Vo0MD 0Ax1ULHmnKP7jjGXNzbVl9T7wZPqPaxnUu/eXZS4MvzbNYRg8Fz0v/brwy8DAfC6GClLXu3R558Jw jGqSR3PLsT0d1aenTlMYP5ERG8oMEGWYULheFtJyXbIcVWEnjyiRa5WlRqzs8TaGjh2qOEpcAtNK8 1RxWo+s0aJ5opgvrq/0Km9z2pdOKaARAsewDGdvOFXeGMquGodOwPxALEd34IFc+osxwI++7Grc5S 7evjvtjw==; Received: from [50.102.16.97] (port=38195) by bay.acenet.us with esmtpsa (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.91) (envelope-from ) id 1gziJF-007syc-6n; Fri, 01 Mar 2019 08:34:41 -0500 Subject: Re: PostgreSQL vs SQL/XML Standards To: Ramanarayana , Pavel Stehule References: <201901191335.kbjzsoefmkoa@alvherre.pgsql> <5C438776.9080103@anastigmatix.net> <7c345302-ade1-eedf-dc33-47cc40da4943@2ndquadrant.com> <5C4B1F2F.2000106@anastigmatix.net> <8c02f9b5-965e-ce51-2b20-e70c0d46a6a0@2ndquadrant.com> Cc: Alvaro Herrera , Markus Winand , Tom Lane , PostgreSQL Hackers , Peter Eisentraut From: Chapman Flack Message-ID: <5C7934EA.8010205@anastigmatix.net> Date: Fri, 1 Mar 2019 08:34:34 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-OutGoing-Spam-Status: No, score=-96.8 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - bay.acenet.us X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - anastigmatix.net X-Get-Message-Sender-Via: bay.acenet.us: authenticated_id: chap@anastigmatix.net X-Authenticated-Sender: bay.acenet.us: chap@anastigmatix.net X-Source: X-Source-Args: X-Source-Dir: X-From-Rewrite: unmodified, already matched List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 03/01/19 07:15, Ramanarayana wrote: > Hi, > I have tested bug fixes provided by all the patches. They are working > great. I found one minor issue > > select * from xmltable('*' PASSING 'pre arg?>&deeppost' COLUMNS x XML PATH '/'); > > The above query returns the xml. But there is an extra plus symbol at the > end > > pre&deeppost+ Hi, Are you sure that isn't the + added by psql when displaying a value that contains a newline? What happens if you repeat the query but after the psql command \a to leave the output unaligned? Thanks! -Chap