Re: GSoC project suggestion: PIVOT ? - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: GSoC project suggestion: PIVOT ?
Date
Msg-id CAFcNs+qXDcYX7yDn0L1_+Foz+cCdAJB+p4dV70UATmdXNKTo5A@mail.gmail.com
Whole thread Raw
In response to GSoC project suggestion: PIVOT ?  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: GSoC project suggestion: PIVOT ?
List pgsql-hackers
<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>

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: issue log message to suggest VACUUM FULL if a table is nearly empty
Next
From: Michael Paquier
Date:
Subject: Re: GSoC project suggestion: PIVOT ?