Comparing PostgreSQL JSON Values

  • 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.

Thanks for reading! If you have any questions or comments, please send me a note on Twitter.