Re: crosstab - Mailing list pgsql-general

From Vincent Veyron
Subject Re: crosstab
Date
Msg-id 1346784707.8977.6.camel@asus-1001PX.home
Whole thread Raw
In response to crosstab  (punnoose <punnoose.pj@dwisesolutions.com>)
Responses Re: crosstab  (dinesh kumar <dineshkumar02@gmail.com>)
Re: crosstab  (Aram Fingal <fingal@multifactorial.com>)
List pgsql-general
Le mardi 04 septembre 2012 à 08:39 -0700, punnoose a écrit :
> hi all
> How could i use crostab to display variable number of columns. in the output
> There could be variable number of columns

see the documentation for Additional Supplied Modules, in your case
tablefunc :

http://www.postgresql.org/docs/9.1/static/tablefunc.html


--
Vincent Veyron
http://marica.fr/
Gestion informatique des sinistres d'assurances et des dossiers contentieux pour le service juridique



pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: "Too far out of the mainstream"
Next
From: dinesh kumar
Date:
Subject: Re: crosstab