Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version


PostgreSQL 14.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit



SELECT 1


with vals (val, type) as (
  values ('null'::json, 'json'), 
         ('0'::json, 'json'), 
         ('2'::json, 'json'), 
         ('"Some Text"'::json, 'json')
)

select type, val, val->0 as "->", val->>0 as "->>", val#>'{}' as "#>", val#>>'{}' as "#>>"
  from vals;


type
val
->
->>
#>
#>>


json
null
null
null
null
null

json
0
null
null
0
0

json
2
null
null
2
2

json
"Some Text"
null
null
"Some Text"
Some Text



SELECT 4


with vals (val, type) as (
  values ('null'::jsonb, 'jsonb'), 
         ('0'::jsonb, 'jsonb'), 
         ('2'::jsonb, 'jsonb'), 
         ('"Some Text"'::jsonb, 'jsonb')
)
select type, val, val->0 as "->", val->>0 as "->>", val#>'{}' as "#>", val#>>'{}' as "#>>"
  from vals;


type
val
->
->>
#>
#>>


jsonb
null
null
null
null
null

jsonb
0
0
0
0
0

jsonb
2
2
2
2
2

jsonb
"Some Text"
"Some Text"
Some Text
"Some Text"
Some Text



SELECT 4

type	val	->	->>	#>	#>>
json	null	null	null	null	null
json	0	null	null	0	0
json	2	null	null	2	2
json	"Some Text"	null	null	"Some Text"	Some Text

type	val	->	->>	#>	#>>
jsonb	null	null	null	null	null
jsonb	0	0	0	0	0
jsonb	2	2	2	2	2
jsonb	"Some Text"	"Some Text"	Some Text	"Some Text"	Some Text