Re: [GENERAL] Desired behavior for || (jsonb_concat)

On Thu, Jul 6, 2017 at 3:25 PM, Seamus Abshere wrote: > hi, > > # select '{"a":1}'::jsonb || null; > ?column? > -- > null > (1 row) > > Is there a theoretical reason that this has to return null as opposed to > just {"a":1}? > > Most operators in SQL, when given a

[GENERAL] Desired behavior for || (jsonb_concat)

hi, # select '{"a":1}'::jsonb || null; ?column? -- null (1 row) Is there a theoretical reason that this has to return null as opposed to just {"a":1}? Thanks, Seamus -- Seamus Abshere, SCEA https://github.com/seamusabshere https://linkedin.com/in/seamusabshere https://www.faraday.io