From: Richard Huxton <dev@archonet.com>
To: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-sql@postgresql.org
Cc: terry@ashtonwoodshomes.com
Cc: chaudhar@umich.edu
Subject: Re: Generating a cross tab (pivot table)
Date: Thu, 7 Nov 2002 12:15:31 +0000
Message-ID: <200211071215.32235.dev@archonet.com> (raw)
In-Reply-To: <3DCA52E2.5529E893@rodos.fzk.de>
References: <3DCA52E2.5529E893@rodos.fzk.de>
On Thursday 07 Nov 2002 11:47 am, Christoph Haller wrote:
> Regarding to Terry's request on multiple aggregates and
> Shahbaz's request for generating a cross tab ( pivot table )
> in September, I've found an excellent example on a german inet page
> http://www.itrain.de/
> I've translated it and think it's useful for many who subscribed
> (I hope so, maybe it was told before, but I couldn't find
> anything about this topic in the techdecs).
Very useful. Also note there are some examples of how to produce crosstab
results in the table-functions contrib directory in 7.3
--
Richard Huxton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, ch@rodos.fzk.de, terry@ashtonwoodshomes.com, chaudhar@umich.edu
Subject: Re: Generating a cross tab (pivot table)
In-Reply-To: <200211071215.32235.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox