Skip to main content

jsonb_object_agg

Function jsonb_object_agg 

Source
pub fn jsonb_object_agg<'a, V, K, Val>(
    key: K,
    value: Val,
) -> SQLExpr<'a, V, <V::DialectMarker as DialectTypes>::Jsonb, Null, Agg>
where V: SQLParam + 'a, V::DialectMarker: PostgresAggregateSupport, K: Expr<'a, V>, Val: Expr<'a, V>,
Expand description

JSONB_OBJECT_AGG - aggregates key/value pairs into a JSONB object (PostgreSQL).

ยงExample

use drizzle_core::expr::jsonb_object_agg;

// SELECT JSONB_OBJECT_AGG(settings.key, settings.value)
let obj = jsonb_object_agg(settings.key, settings.value);