select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Functions and aggregates

pg_rowalesce

rowalesce() is like coalesce(), but for rows and other composite types.

pgext.cloud · Source code · Documentation · Control file · PGXN

Overview

Packagepg_rowalesce
Version0.1.12
RepositoryUnspecified
Extension typeStandard
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars8
Latest commit2023-11-28
Latest release2023-11-29
Catalogue updated2026-08-30

Related extensions

Requires

hstoredata type for storing sets of (key, value) pairs

See also

pgbsonBSON data type and accessor functions for PostgreSQL
jsquerydata type for jsonb inspection
pgjqUse jq in Postgres
pg_projectionMongoDB-like read projections for JSONB in PostgreSQL
monqMongoDB-like query support for jsonb data
pgkvRedis-like key-value store for PostgreSQL using JSONB-backed PL/pgSQL functions
jsonb_deep_sumRecursively sum numeric fields in JSONB objects
jsonknifeUseful jsonb inspection and transformation functions