Re: crosstab

That is correct,

Re you additional question re PL/R or get data from Pg in plain R - I am
not sure it will be that much faster inside PL/R...

I dont think there will be too much difference in execution time... Would
be good to test it... and would be good to share results with us :)

Thanks,

Misa

2012/9/4 Aram Fingal <fingal(at)multifactorial(dot)com>

>
> On Sep 4, 2012, at 4:18 PM, Misa Simic wrote:
>
> Inside PL/R you can take the same table as it is (unpivoted) as your
> data.frame and then pivot it inside R using reshape package,,, And then
> inside PL/R function do whatever you would like to do with data i.e export
> to whatever... - but you cant return it pivoted as result of Postgres
> function..
>
>
> Okay, you just answered my question in reply to Joe Conway (crossed in
> the mail). So I could just use write.table() from R to save to disk or I
> might even have the PL/R procedure write a heatmap or PCA plot to disk,
> again without returning any rows to PostgreSQL.
>
> -Aram
>
>
>
>