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}]