Sorry, I uploaded the wrong file. I uploaded a new patch with the modified document. Please take a review. Thanks!
From: Yan Chengpeng <[email protected]> Date: Monday, December 9, 2024 at 21:22 To: jian he <[email protected]>, Andrew Dunstan <[email protected]> Cc: [email protected] <[email protected]> Subject: Re: [PATCH] Fix jsonb comparison for raw scalar pseudo arrays If many people are already using this ‘wrong’ behavior. I agree to change the doc. I also think using ‘null’ may be a better choice. Thanks for your comments. From: jian he <[email protected]> Date: Monday, December 9, 2024 at 16:56 To: Andrew Dunstan <[email protected]> Cc: Yan Chengpeng <[email protected]>, [email protected] <[email protected]> Subject: Re: [PATCH] Fix jsonb comparison for raw scalar pseudo arrays On Sun, Dec 8, 2024 at 10:58 PM Andrew Dunstan <[email protected]> wrote: > > So the actual sort order as implemented is, AIUI, > > Object > Non-Empty-Array > Boolean > Number > String > Null > Empty-Array > > which is ugly, but fortunately not many apps rely on jsonb sort order. > > Nobody else has commented, so I propose to apply this patch documenting the > anomaly. > while at it. we can fix the appearance of jsonb null. since select jsonb 'Null'; select jsonb 'NULL'; will fail. so maybe change <replaceable>Null</replaceable> in <synopsis> section and <replaceable>NULL</replaceable> to <replaceable>null</replaceable>
json-doc-update.patch
Description: json-doc-update.patch
