| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Felix Homann" <fexpop(at)onlinehome(dot)de> |
| Cc: | "Sam Mason" <sam(at)samason(dot)me(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Alias name from subquery |
| Date: | 2008-09-30 17:53:59 |
| Message-ID: | dcc563d10809301053j2105e688o7fc5aef8e40a6d1e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Sep 30, 2008 at 11:45 AM, Felix Homann <fexpop(at)onlinehome(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Diehl | 2008-09-30 18:00:11 | Re: Can't cast from char to integer... |
| Previous Message | Felix Homann | 2008-09-30 17:45:32 | Re: Alias name from subquery |