如何在postgresql中为唯一(不包括顺序) JSONB列创建约束

CREATE OR REPLACE FUNCTION jsonb_to_string(jsonb_column JSONB)
RETURNS TEXT AS $$
BEGIN
    RETURN (
        SELECT MD5(array_to_string(array_agg(value), ','))
        FROM jsonb_object_keys(jsonb_column)
        CROSS JOIN LATERAL jsonb_extract_path_text(jsonb_column, ARRAY[key])
    );
END;
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION check_unique_jsonb()
RETURNS TRIGGER AS $$
BEGIN
    IF EXISTS (
        SELECT 1
        FROM table_name
        WHERE jsonb_to_string(NEW.jsonb_column) = jsonb_to_string(jsonb_column)
          AND id <> NEW.id -- 排除当前行
    ) THEN
        RAISE EXCEPTION 'Duplicate JSONB value';
    END IF;
    RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER jsonb_unique_trigger
BEFORE INSERT OR UPDATE ON table_name
FOR EACH ROW
EXECUTE FUNCTION check_unique_jsonb();