I have a Postgres table signal which has a JSON column called signal_range and I want to split the range into different columns in a SELECT query.
Brand signal_range
AB {"Weak": {"low": 15, "high": 120}, "Strong": {"low": null, "high": -240}, "Average": {"low": -240, "high": 15}}
CA
FZ {"Weak": {"low": 10, "high": 100}, "Strong": {"low": null, "high": -200}, "Average": {"low": -200, "high": 10}}
Expected output
Brand Weak_low Weak_high Strong_low Strong_high Average_low Average_high
AB 15 120 -240 -240 15
CA
FZ 10 100 -200 -200 10
Is there anyway we can get this output in a select query?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…