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 1qojLg-002byF-04 for pgsql-docs@arkaria.postgresql.org; Fri, 06 Oct 2023 11:50:28 +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 1qojLd-006Abu-Ft for pgsql-docs@arkaria.postgresql.org; Fri, 06 Oct 2023 11:50:26 +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 1qojLd-006Abm-7f for pgsql-docs@lists.postgresql.org; Fri, 06 Oct 2023 11:50:26 +0000 Received: from relay6-d.mail.gandi.net ([2001:4b98:dc4:8::226]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qojLb-000aad-D7 for pgsql-docs@lists.postgresql.org; Fri, 06 Oct 2023 11:50:25 +0000 Received: by mail.gandi.net (Postfix) with ESMTPSA id 6FBC7C0002; Fri, 6 Oct 2023 11:50:18 +0000 (UTC) Message-ID: <01bb976d-a11c-49d4-8230-1e7eed42c1d9@postgresfriends.org> Date: Fri, 6 Oct 2023 12:50:17 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: JSON type unsupported To: Peter Eisentraut , Erki Eessaar , "pgsql-docs@lists.postgresql.org" References: <4ce8a8d1-fc85-2170-9890-f9d82057e2c9@eisentraut.org> Content-Language: en-US From: Vik Fearing In-Reply-To: <4ce8a8d1-fc85-2170-9890-f9d82057e2c9@eisentraut.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-GND-Sasl: vik@postgresfriends.org List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/6/23 11:57, Peter Eisentraut wrote: > On 26.09.23 17:31, Vik Fearing wrote: >> For example, we do not have the JSON_SERIALIZE(), JSON()[1], >> JSON_SCALAR() functions.  We don't have the IS JSON predicate, or a >> few other things hiding behind T801. > > AFAICT, commit 03734a7fed, which is new in master, adds exactly those, > so maybe we could toggle this feature to supported? That is better than before, but even those functions are not complete. I am okay with flipping to supported but with a note saying there are many subfeatures missing. -- Vik Fearing