using cross tab and pivot table function

Question

Possibility of using cross tab and pivot table function in postgres 8.3 version

I know it is possible with postgres 9.x version, but wanted to know by any chance we can use it with the older versions of postgres.

I am using hibernate for the database connectivity.

score 0 · Accepted Answer · edited May 23 '17 at 10:24

0

Yes, the additional module tablefunc providing several variants of the crosstab() function is available for PostgreSQL 8.3.

More Info on how to install additional modules here.
Also, check out the tag crosstab, combine it with postgresql, you'll find a number of examples under related questions.

edited May 23 '17 at 10:24

Community

answered Oct 12 '12 at 05:33

1 Answers1