3 ms·
Any real reason why JSONB shouldn’t support those operators? (Does it do something else with them?)
by chrismorgan 10y ago
Any real reason why JSONB shouldn’t support those operators? (Does it do something else with them?)
- ht85 10y agohstore are very different from JSON in the sense that they are a flat key/value structure, which is exactly what a record/row in the database is. This is why you have operators to convert and combine hstore values and actual records. The ability to diff might come at some point, but interest for it is probably low because of the purpose of JSONB. Diffing works best for similar structure, and if you're storing things with similar structure in postgres, I doubt you're going to use JSONB. Diffing deep trees is also very costly.