Postgres Pro
Downloads
Home   >   mailing lists

Re: How to alias attributes in an ARRAY_AGG expression - Mailing list pgsql-novice

From David Johnston
Subject Re: How to alias attributes in an ARRAY_AGG expression
Date
Msg-id 1384364372141-5778196.post@n5.nabble.com
Whole thread Raw
In response to Re: How to alias attributes in an ARRAY_AGG expression  (Claudio Poli <masterkain@gmail.com>)
Responses Re: How to alias attributes in an ARRAY_AGG expression
List pgsql-novice
Tree view 
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.

pgsql-novice by date:

Previous
From: Claudio Poli
Date:
Subject: Re: How to alias attributes in an ARRAY_AGG expression
Next
From: Claudio Poli
Date:
Subject: Re: How to alias attributes in an ARRAY_AGG expression