In our DB we have tables, that have 6-8 M records, this data is static and in order of performance optimization we decided to store some data from this tables in separate table, and for predefined filters use the values…
In a table called temporay_data with a data field called temporary_data too, filled with this JSON structure { "FormPayment": { "student": [ { "fullname": "name student1 ", "rate": 210, "meal": 7, "mealValue": 175, "finalValue": 385, "role": "student", "willPay": true },…
I have a jsonb column in the following format: { "targets": { "01d7de90-57fd-4c4f-b7c9-3b956762fe25": { "id": "01d7de90-57fd-4c4f-b7c9-3b956762fe25", "name": "target1" }, "0f43e1fe-132e-464b-8284-4a9947a70c1c": { "id": "0f43e1fe-132e-464b-8284-4a9947a70c1c", "name": "target2" } }, "suggestions": [ { "items": [ { "id": "foo", "code": "item1" } ], "groupId":…
I have a table which stores timestamps but they're in a jsonb array column like this: id cycles 5 [{"end": "2022-10-18T18:31:34.529667Z", "start": "2022-10-05T19:01:51.400124Z"}, {"start": "2022-10-28T08:27:13.682084Z"}] 6 [{"start": "2022-10-03T16:37:38.119236Z"}] 7 [{"end": "2022-11-14T11:30:17.964960Z", "start": "2022-11-08T19:20:20.413133Z"}] I need to the values from the…
I have a two part question We have a PostgreSQL table with a jsonb column. The values in jsonb are valid jsons, but they are such that for some rows a node would come in as an array whereas for…
I have a jsonb column such that: | id | fee | |----------|----------------------------------------| | 1 | "[{"Step": "step1", "Value": "10"}]" | | 2 | "[{"Step": "step1", "Value": "999"}]" | | 3 | [] | And I want to calculate the…