I am trying to use aggregate functions in materialized views in RisingWave, but I encountered errors with jsonb_agg and jsonb_object_agg. Which aggregate functions are supported in materialized views?
Charlie
Asked on Oct 13, 2023
json_agg
and json_object_agg
are supported in streaming mode.array_agg
can be used as an alternative to jsonb_agg
in materialized views.json_agg
and json_object_agg
are similar to array_agg
and jsonb_agg
respectively, with the main difference being the returning data type.