There is a composite type:

CREATE TYPE public.value_telemetry AS (number integer, data character varying(1000));

There is a data value_telemetry[]; variable data value_telemetry[];

How to sort the data variable by the number field in ascending order?

    1 answer 1

    Possible Solution:

    data = ( SELECT array_agg(x) From(SELECT unnest (data)as x ORDER BY 1 ) as r );