Get json value in pl/pgsql

Question

I have json string like '{"ww":11}'

How can i get value 11 in pl/pgsql ?

I try:

json_var := '{"ww":11}'::json

json_var->ww;
json_var->"ww";
json_var.ww;

All of this failed.

Please help! Dmitry

Answer 1

The json type is just text. The advantage of using it is syntax check. Just that.

Check this question