Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Desired behavior for || (jsonb_concat) - Mailing list pgsql-general

From Seamus Abshere
Subject [GENERAL] Desired behavior for || (jsonb_concat)
Date
Msg-id 1499379924.87973.1032871472.55431938@webmail.messagingengine.com
Whole thread Raw
Responses Re: [GENERAL] Desired behavior for || (jsonb_concat)  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: [GENERAL] psql doesn't pass on exported shell environment functions
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Desired behavior for || (jsonb_concat)