Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T8yE9-00055q-BB for pgsql-general@postgresql.org; Tue, 04 Sep 2012 18:51:57 +0000 Received: from smtp05.smtpout.orange.fr ([80.12.242.127] helo=smtp.smtpout.orange.fr) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T8yE4-0002TS-Tb for pgsql-general@postgresql.org; Tue, 04 Sep 2012 18:51:56 +0000 Received: from [192.168.1.10] ([193.251.178.45]) by mwinf5d62 with ME id v6rp1j0030z9ZVd036rpB4; Tue, 04 Sep 2012 20:51:51 +0200 Subject: Re: crosstab From: Vincent Veyron To: punnoose Cc: pgsql-general@postgresql.org In-Reply-To: <1346773199616-5722632.post@n5.nabble.com> References: <1346773199616-5722632.post@n5.nabble.com> Content-Type: text/plain; charset="ISO-8859-15" Date: Tue, 04 Sep 2012 20:51:47 +0200 Message-ID: <1346784707.8977.6.camel@asus-1001PX.home> Mime-Version: 1.0 X-Mailer: Evolution 2.30.3 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201209/93 X-Sequence-Number: 190109 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