Get json value in pl/pgsql
The json
type is just text. The advantage of using it is syntax check. Just that.
Check this question
you need to typecast it to Json in order to do that.
select '{"ww":11}'::json->'ww' as ww_value
returns ....
11
The json
type is just text. The advantage of using it is syntax check. Just that.
Check this question
you need to typecast it to Json in order to do that.
select '{"ww":11}'::json->'ww' as ww_value
returns ....
11