Comparing PostgreSQL JSON Values

Written 2020-11-06

SQL
When comparing a JSON value to a non-JSON value, the easiest way is to use the text operators and coalesce.
- coalesce(a->>'value', '0')::int > 10
- This way, if the coalesce works whether the value is null or null::jsonb.