You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT jsonb_test('{"a":1, "b":{"c": 2}}'::json) works fine
the type jsonb seems to be internal to the pg database, that is, not stored as a string but parsed, so don't see quite how {}::jsonb as an argument makes sense
that said, there appears to be a bug, nonetheless, plv8 claims to support json, notjsonb.
I don't see the pg engine supporting json in any fashion except for text, so it seems to me nothing gained anywhere by typing something to jsonb within a javascript function.
pl/v8 can't seem to properly handle
JSONB
.Test case
Having the following function:
When running:
will result in
{"a": 1, "b": {"c": 2}}
which is the expected result.When running
we get
"{\"a\": 1, \"b\": {\"c\": 2}}"
, which is not ideal.The text was updated successfully, but these errors were encountered: