postgresql json和jsonb问题记录

jsonb会打乱原json属性顺序，但是支持索引

原json：

[{"ITEM": "W(nm)","HZ1": 0,"HZ2": 0}, {"ITEM": "OL(nm)","HZ1": 0,"HZ2": 0}, {"ITEM": "OR(nm)","HZ1": 0,"HZ2": 0}
]

CREATE TABLE mc.test (id int8 GENERATED BY DEFAULT AS IDENTITY NOT NULL,json_detail jsonb NOT NULL
);

json类型保存数据库后：

[{"HZ1": 0, "HZ2": 0, "ITEM": "W(nm)"}, {"HZ1": 0, "HZ2": 0, "ITEM": "OL(nm)"}, {"HZ1": 0, "HZ2": 0, "ITEM": "OR(nm)"}]

改成json类型后：

CREATE TABLE mc.test (id int8 GENERATED BY DEFAULT AS IDENTITY NOT NULL,json_detail json NOT NULL
);

[{"ITEM":"W(nm)","HZ1":0,"HZ2":0},{"ITEM":"OL(nm)","HZ1":0,"HZ2":0},{"ITEM":"OR(nm)","HZ1":0,"HZ2":0}]