Extensions / Functions and aggregates
Recursively sum numeric fields in JSONB objects
pgext.cloud · Source code · Documentation · License text · Control file · PGXN
| Package | jsonb_deep_sum |
|---|---|
| Version | 0.0.2 |
| PostgreSQL versions | 10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Stars | 26 |
| Latest commit | 2026-06-17 |
| Latest release | 2020-02-22 |
| Catalogue updated | 2026-08-30 |
| pgbson | BSON data type and accessor functions for PostgreSQL |
| jsquery | data type for jsonb inspection |
| pgjq | Use jq in Postgres |
| jsonb_opx | hstore-style functions and operators for jsonb |
| jsonb_extend | Merge two or more jsonb values |
| jsonb_delete | hstore-style delete function and operator for jsonb |
| jsonb_extra | Extra JSONB functions |
| jsonb_explorer | Inspect jsonb trees and paths |
| jsonb_delete_array | Delete jsonb keys or string elements listed in a text array |
| jsonb_set_lax | Backport of PostgreSQL 13 jsonb_set_lax for PostgreSQL 9.5 through 12 |