The data type information from the array_expression which resolves to an ARRAY data type is used to set the return type of ARRAY_AGG.
The data type information from the array_expression which resolves to an ARRAY data type is used to set the return type of ARRAY_AGG.