Re: GSoC project suggestion: PIVOT ?

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