Comparing PostgreSQL JSON Values
- 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
coalesceworks whether the value is
Thanks for reading! If you have any questions or comments, please send me a note on Twitter. And if you enjoyed this, I also have a newsletter where I sometimes write about tech thoughts, interesting things I've read, and project updates.