Re: Question(s) about crosstab

From: Joe Conway <mail(at)joeconway(dot)com>
To: John Abraham <jea(at)hbaspecto(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, ken(dot)tanzer(at)gmail(dot)com, polobo(at)yahoo(dot)com, scott(dot)marlowe(at)gmail(dot)com
Subject: Re: Question(s) about crosstab
Date: 2013-12-18 23:45:00
Message-ID: 52B2337C.6080609@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/18/2013 05:14 PM, John Abraham wrote:
> On Dec 18, 2013, at 3:52 PM, Joe Conway <mail(at)joeconway(dot)com> wrote:
>> 3) Not possible -- reason was given down thread. Column definition
>> must be known/determinable by the parser prior to query execution.
>
> No, wait, I think you misunderstood my idea. Can’t we have a python
> function that crosstabs the data in python, then creates a new table,
> then inserts that data into the new table by looping through a bunch
> of inserts?

Oh, well I believe you could do that today in plpgsql (build the "create
table as select * from crosstab..." sql as described earlier in this
thread, then execute it), so I'm sure you could do it in plpython as
well. But this isn't generally what people are looking for.

Joe

--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support

In response to

Browse pgsql-general by date

  From Date Subject
Next Message wd 2013-12-19 03:25:48 unexpected pageaddr error in db log
Previous Message Sergey Konoplev 2013-12-18 23:39:07 Re: Replication failed after stalling