On Sun, Mar 30, 2014 at 11:30 PM, Craig Ringer <cr...@2ndquadrant.com> wrote: > > Hi all > > The thought just occurred to me that a PIVOT feature might be a > respectable GSoC project. > > tablefunc/crosstab works, but it's very clumsy to use, and difficult to > consume the data from. Going by Stack Overflow activity, pivot/crosstab > is second only to upsert when it comes to things that users find hard to > do in Pg. > > I haven't investigated what'd be involved in implementing any integrated > form of pivoting, and I'm aware that there are some serious challenges > when it comes to generating a TupleDesc for pivot output. I thought I'd > raise it in case anyone has looked into this and has any comments on > whether this'd be a viable GSoC for an interested student. >
It's a nice idea, but the deadline to students send a proposal was 21th April. Regards, -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Timbira: http://www.timbira.com.br >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello >> Twitter: http://twitter.com/fabriziomello