BUG #15763: JSON nulls not handled properly - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15763: JSON nulls not handled properly
Date
Msg-id 15763-200acd20c49eeff5@postgresql.org
Whole thread Raw
Responses Re: BUG #15763: JSON nulls not handled properly  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #15763: JSON nulls not handled properly  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15763
Logged by:          Jacob Crell
Email address:      jacobcrell@gmail.com
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.


pgsql-bugs by date:

Previous
From: Dingyuan Wang
Date:
Subject: Re: BUG #15758: regr_* return wrong answers for some valid data
Next
From: Tom Lane
Date:
Subject: Re: BUG #15763: JSON nulls not handled properly