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.


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice