Ok, now I understand, thank you.
My solution is to create materialized view with intermediate values and
the create a normal view on top that uses the intermediate values and
the jsonb_build_object function to create the desired result.
Kind regards,
Martijn de Munnik
On 2023-03-11 16:47, To
Martijn de Munnik writes:
> The error is caused by the jsonb_build_object function, is there any
> reason why this function is not IMMUTABLE?
It can invoke arbitrary datatype output functions, some of which are
not immutable. We unfortunately lack any infrastructure that would
allow reasoning th
min'),
'stddev', public.stddev(public.stats_agg("value"::double precision)
FILTER (WHERE "path" = 'navigation.rateOfTurn')),
'skewness', public.skewness(public.stats_agg("value"::double
precision) FILTER (WHERE "path&quo
