Hi,
Comparison of 2 values of type jsonb is allowed.
Comparison of 2 values of type json gives an error.
That seems like an oversight -- or is it deliberate?
Example:
select '42'::json = '{}'::json;
--> ERROR: operator does not exist: json = json
(of course, easily 'solved' by casting but that's not really the point)
Thanks,
Erik Rijkers