Re: Alias name from subquery - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Alias name from subquery
Date
Msg-id dcc563d10809301053j2105e688o7fc5aef8e40a6d1e@mail.gmail.com
Whole thread Raw
In response to Re: Alias name from subquery  (Felix Homann <fexpop@onlinehome.de>)
List pgsql-general
On Tue, Sep 30, 2008 at 11:45 AM, Felix Homann <fexpop@onlinehome.de> wrote:
> Hi Sam,
> In other words, I would like to have a named column for every Name in the
> player table. I _can_ create such a view manually if I know each player.name
> beforehand, but I don't know how to automate it for any given number of
> players. (Think of something like a sparse interaction matrix
> representation.)

Ahhh, you might do better with crosstab functions then.  look up the
tablefunc contrib module.

pgsql-general by date:

Previous
From: Felix Homann
Date:
Subject: Re: Alias name from subquery
Next
From: Mike Diehl
Date:
Subject: Re: Can't cast from char to integer...