Claudio Poli wrote
> create type media_file_detail as (position integer AS myalias);
CREATE TYPE media_file_detail AS (position_alias integer, token_alias text);
... ARRAY_AGG(
(media_files.position, media_files.token)::media_file_detail
) ...
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-alias-attributes-in-an-ARRAY-AGG-expression-tp5778089p5778196.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.