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.