Re: crosstab
| От | Aram Fingal |
|---|---|
| Тема | Re: crosstab |
| Дата | |
| Msg-id | 7455D95E-B02C-4D24-A651-F9D84914A89E@multifactorial.com обсуждение исходный текст |
| Ответ на | Re: crosstab (Misa Simic <misa.simic@gmail.com>) |
| Ответы |
Re: crosstab
Re: crosstab |
| Список | pgsql-general |
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 по дате отправления: