Home > mailing lists

Re: Weird special case in jsonb_concat() - Mailing list pgsql-hackers

From	Zhihong Yu
Subject	Re: Weird special case in jsonb_concat()
Date	December 21, 2020 00:48:39
Msg-id	CALNJ-vSWUjf0bWRrrRQrPJewWj1ax-JUMCErD0MjFhO8DWpmyg@mail.gmail.com Whole thread Raw
In response to	Weird special case in jsonb_concat() (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-hackers

Hi,

w.r.t. the patch,

+select '[3]'::jsonb || '{}'::jsonb;
+ ?column?
+----------
+ [3, {}]
+(1 row)
+
+select '3'::jsonb || '[]'::jsonb;

Should cases where the empty array precedes non-empty jsonb be added ?

select '[]'::jsonb || '3'::jsonb;

select '{}'::jsonb || '[3]'::jsonb;

Cheers

From: Andres Freund
Date: 21 December 2020, 00:27:28
Subject: Improving LWLock wait events

From: Masahiko Sawada
Date: 21 December 2020, 00:57:03
Subject: Re: Commit fest manager for 2021-01