News for hackers. Stuff that matters.
Re:Unstructured Datatypes in Postgres – Hstore vs. JSON vs. ... by agwa on Wednesday July 20, 2016 @10:51PM (#12134280)
An even bigger difference is that with jsonb, strings and numbers are converted to their equivalent PostgreSQL types. That means that strings can't contain null characters or characters that violate the database's encoding rules. Consequentially, not all valid JSON documents can be stored in jsonb, which is usually fine but can sometimes introduce headaches.

There are no comments on this comment yet.