Re: How to alias attributes in an ARRAY_AGG expression

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.