PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15763
PG Version9.6.8
OSAWS RDS
Opened2019-04-16 19:13:13+00
Reported byJacob Crell
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15763
Logged by:          Jacob Crell
Email address:      (redacted)
PostgreSQL version: 9.6.8
Operating system:   AWS RDS
Description:        

SELECT '{"test":null}'::json->>'test' will return a null
SELECT '{"test":null}'::json->'test' will return a string 'null'
The 2nd option seems like it should also return a null.

Messages

DateAuthorSubject
2019-04-16 19:13:13+00PG Bug reporting formBUG #15763: JSON nulls not handled properly
2019-04-16 19:29:00+00Tom LaneRe: BUG #15763: JSON nulls not handled properly
2019-04-16 19:35:48+00"David G(dot) Johnston"Re: BUG #15763: JSON nulls not handled properly
2019-04-16 19:57:38+00Jacob CrellRe: BUG #15763: JSON nulls not handled properly
2019-04-16 20:10:52+00Tom LaneRe: BUG #15763: JSON nulls not handled properly