Re: crosstab

Поиск
Список
Период
Сортировка
От Misa Simic
Тема Re: crosstab
Дата
Msg-id CAH3i69nNB2nTz1=EuisK1FKU0jBZQ-uN_n5pqbJEc-iTC4EKsw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: crosstab  (Aram Fingal <fingal@multifactorial.com>)
Список pgsql-general
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@multifactorial.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




В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: "Too far out of the mainstream"
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: crosstab