News for hackers. Stuff that matters.
Re:Unstructured Datatypes in Postgres – Hstore vs. JSON vs. ... by ht85 on Thursday July 21, 2016 @01:10AM (#12134854)
Probably the biggest gotcha of JSON is that there is no equality operator implemented for it. The reason is the philosophy of postgres to never do anything if you don't do it right, and you can't compare JSON as strings because of key order and whitespace.

In itself it doesn't seem like a big deal, but you'll lose generic things that normally always work. An example would be a trigger that updates an updated_at column, by checking

IF OLD IS DISTINCT FROM NEW

This syntax normally works on everything, but will throw if a column is of type JSON.

There are no comments on this comment yet.