Re: Crosstab SQL Question - Mailing list pgsql-general

From Paul Condon
Subject Re: Crosstab SQL Question
Date
Msg-id 39498E33.280E0E80@quiknet.com
Whole thread Raw
In response to Crosstab SQL Question  (Matthew <matt@ctlno.com>)
Responses Re: Re: Crosstab SQL Question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
The crosstab functionality in MS Access is (I believe) a seamless integration of Access and Excel, where pivot tables are actually implemented.

As others have indicated, crosstabs are available in other data analysis systems.
I have found a nice implementation of crosstabs in R, which is a system/language for statistical analysis, data display, and data plotting. <www.r-project.org>

R is a version of S, which is also a statistical analysis language. There are lots of issues with how one displays a crosstab which are not easily addressed within the context of RDBMS. I suggest the PostgreSQL team not plan to add crosstabs to PostgreSQL, but simply refer enquiries about crosstabs to the R team. The link between the two is not difficult to establish.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: NOTICE: DateStyle is Postgres with Eropean convention
Next
From: Bill
Date:
Subject: large data values through ODBC?