On Sun, Dec 8, 2024 at 10:58 PM Andrew Dunstan <and...@dunslane.net> 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>
