How to calculate aggregation in json field in postgresql?

E

Eugene2020-08-27 16:20:45

PostgreSQL

Eugene, 2020-08-27 16:20:45

[{"id":1, "amount": 5}, {"id":2, "amount": 10}]
How to calculate relative amount using sql? I want to get
id = 1, amount = 5/15
id = 2, amount 10/15

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

I

impressive172020-08-21 16:05:13

Where are database access logs stored in Postgresql? 1Reply

B

beduin012021-12-09 09:24:51

How are UPDATE requests executed? 1Reply

I

Ivan Balan2014-03-08 15:55:50

How to share postgresql over local network? 1Reply

A

AlexBoss2021-12-11 07:32:09

How to correctly organize a reference to a value in a related table? 2Reply

Y

YogurtJoe2016-05-12 12:13:26

Python: Connecting to Postgres DB via SSH? 0Reply

Didn't find what you were looking for?

Ask your question