On Tue, Sep 30, 2008 at 11:45 AM, Felix Homann <[EMAIL PROTECTED]> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
