Unable to remove property from JSON field

I'm trying to remove a JSON property. using the - syntax, but it's not working on a supabase instance. It works on other postgres instances, it just seems to be an issue with a supabase instance:

SELECT '{"a": {"key":"value"}, "b": 2, "c": true}'::jsonb - 'a';


Which gives me this error:
[22P02] ERROR: invalid input syntax for type json Detail: Token "a" is invalid.
Was this page helpful?