Re: crosstab

From: Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>
To: punnoose <punnoose(dot)pj(at)dwisesolutions(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: crosstab
Date: 2012-09-04 18:51:47
Message-ID: 1346784707.8977.6.camel@asus-1001PX.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • crosstab at 2012-09-04 15:39:59 from punnoose

Responses

Browse pgsql-general by date

  From Date Subject
Next Message dinesh kumar 2012-09-04 19:01:12 Re: crosstab
Previous Message Kevin Grittner 2012-09-04 18:13:03 Re: "Too far out of the mainstream"