On Dec 18, 2013, at 3:52 PM, Joe Conway <mail@joeconway.com> wrote:
>
>> 3) Can't "someone" write a pl language routine that does it better? I'd be willing to work on the core
>> functionality in python if someone else would be willing to embed it in plpython (I've never used plpython.)
>
> 3) Not possible -- reason was given down thread. Column definition must be known/determinable by the parser prior to
queryexecution.
No, wait, I think you misunderstood my idea. Can’t we have a python function that crosstabs the data in python, then
createsa new table, then inserts that data into the new table by looping through a bunch of inserts?
The parser wouldn’t’ need to know a thing. There would be no output from the function itself, it would just create a
tablewhile it ran. (I suppose it could return the name of the table, or a boolean success/fail flag, or return the
numberof columns that were created, but all of these are simple things knowable to the parser in advance.)
I’ve written functions before in plpgsql that create tables behind the scenes, and basically return no output
themselves.
—
John