Re: crosstab - Mailing list pgsql-general

From dinesh kumar
Subject Re: crosstab
Date
Msg-id CALnrH7p3AmWx3QyqDVf1v0pJm7-SZcw_b+HavxSeBjuLCNn-Yg@mail.gmail.com
Whole thread Raw
In response to Re: crosstab  (Vincent Veyron <vv.lists@wanadoo.fr>)
List pgsql-general
This is really good feature (crostab) to implement .. 

Best Regards,


On Wed, Sep 5, 2012 at 12:21 AM, Vincent Veyron <vv.lists@wanadoo.fr> wrote:
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



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Vincent Veyron
Date:
Subject: Re: crosstab
Next
From: Aram Fingal
Date:
Subject: Re: crosstab