Re: How to alias attributes in an ARRAY_AGG expression

Awesome, thank you very much.
C.

On Wed, Nov 13, 2013 at 6:39 PM, David Johnston <polobo(at)yahoo(dot)com> wrote:

> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>