Обсуждение: GSoC project suggestion: PIVOT ?

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.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services

On Mon, Mar 31, 2014 at 1:36 PM, Fabrízio de Royes Mello
<fabriziomello@gmail.com> wrote:
> It's a nice idea, but the deadline to students send a proposal was 21th
> April.
21st of March. All the details are here:
http://www.postgresql.org/developer/summerofcode/
--
Michael

On 03/31/2014 12:49 PM, Michael Paquier wrote:
> On Mon, Mar 31, 2014 at 1:36 PM, Fabrízio de Royes Mello
> <fabriziomello@gmail.com> wrote:
>> It's a nice idea, but the deadline to students send a proposal was 21th
>> April.
> 21st of March. All the details are here:
> http://www.postgresql.org/developer/summerofcode/

Ah, thanks.

There's always next year. Still curious about whether anyone's
investigated it / tried it out.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services

On Mon, Mar 31, 2014 at 1:36 PM, Fabrízio de Royes Mello
<fabriziomello@gmail.com> wrote:
> It's a nice idea, but the deadline to students send a proposal was 21th
> April.
21st of March. All the details are here:
http://www.postgresql.org/developer/summerofcode/

On Mon, Mar 31, 2014 at 1:14 AM, Craig Ringer <craig@2ndquadrant.com> wrote:
> On 03/31/2014 12:49 PM, Michael Paquier wrote:
>> On Mon, Mar 31, 2014 at 1:36 PM, Fabrízio de Royes Mello
>> <fabriziomello@gmail.com> wrote:
>>> It's a nice idea, but the deadline to students send a proposal was 21th
>>> April.
>> 21st of March. All the details are here:
>> http://www.postgresql.org/developer/summerofcode/
>
> Ah, thanks.
>
> There's always next year. Still curious about whether anyone's
> investigated it / tried it out.

I bet this is more complex than a typical GSoC student can handle.
Unless it's Alexander Korotkov.  :-)

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company