Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qZwgy-007qa9-J0 for pgsql-hackers@arkaria.postgresql.org; Sat, 26 Aug 2023 17:03:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qZwfy-00BIGe-NW for pgsql-hackers@arkaria.postgresql.org; Sat, 26 Aug 2023 17:02:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qZwfy-00BIGN-DK for pgsql-hackers@lists.postgresql.org; Sat, 26 Aug 2023 17:02:18 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qZwfq-001BtB-HY for pgsql-hackers@lists.postgresql.org; Sat, 26 Aug 2023 17:02:17 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 4C8AF32008FA; Sat, 26 Aug 2023 13:02:07 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Sat, 26 Aug 2023 13:02:07 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1693069326; x= 1693155726; bh=8EwyqUNV/teldFSj2UTw7TnbuZetfMWhjWQiSsJ7OYs=; b=Y 6c3ymQDmLJJjaupFaKz5X94p1xoe3kJ0DLoG2Y/VIhIGeaIloQA16gnjHL5yk0Sl 08LkaFyFwOYkvoyFbB8IP2ereK/F8rDV05dJZWGwhHLMVKCLzlfOxTRt0tsZL9H2 lm103Sq8sfiHcP6JzCHD7yz+9eceToCOzqvP/L74eA4wdAwaBCEBIGffCBRXw54Q ZXrbf7VEV1bgN9qtH2jhRYFJuS1sADJxLYbJ623s/GbxuCAR7OYqNpmGC+Cektn6 g3ya/aRQNv6K3CoBzf2TxTbd6E23pKpNyIuJycvIlGm0kP4OcpZoCE0MrIl+1E9q QRTOQgORpMu47uUtMkz3A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudeftddguddtjecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhv rghrohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorh hgqeenucggtffrrghtthgvrhhnpedvkedtffduffdtffffheffhfejjefhgfeiueeukeej keffgfdufffhudffffeuveenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtoh hmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghl vhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 26 Aug 2023 13:02:05 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id A30FDA9; Sat, 26 Aug 2023 19:02:02 +0200 (CEST) Date: Sat, 26 Aug 2023 19:02:02 +0200 From: Alvaro Herrera To: Chapman Flack Cc: Vik Fearing , Jim Jones , PostgreSQL Hackers Subject: Re: [PATCH] Add XMLText function (SQL/XML X038) Message-ID: <20230826170202.hwzdopprhn62gfpf@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2023-Aug-25, Chapman Flack wrote: > On 2023-08-25 10:49, Vik Fearing wrote: > > I do not think this should be addressed in this patch because > > there are quite a lot of functions that need to handle this. > > Indeed, as described in [0], we still largely provide the SQL/XML:2003 > notion of a single XML datatype, not the distinguishable XML(DOCUMENT), > XML(CONTENT), XML(SEQUENCE) types from :2006 and later, which has a > number of adverse consequences for developers[1], and that wiki page > proposed a couple possible ways forward[2]. Sadly, all the projects seem to have been pretty much abandoned in the meantime. Zorba has been dead for 9 years, xqilla for 6. Even XQC, the API they claim to implement, is dead. It sounds unlikely that there is *any* way forward here. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ "El Maquinismo fue proscrito so pena de cosquilleo hasta la muerte" (Ijon Tichy en Viajes, Stanislaw Lem)