Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id F1FA9475A1E for ; Thu, 7 Nov 2002 07:30:23 -0500 (EST) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by postgresql.org (Postfix) with ESMTP id 1FD50475461 for ; Thu, 7 Nov 2002 07:30:21 -0500 (EST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-35.mail.demon.net with esmtp (Exim 3.36 #2) id 189lnW-0002fB-0U; Thu, 07 Nov 2002 12:30:10 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id F28D11668A; Thu, 7 Nov 2002 12:15:21 +0000 (GMT) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 7544216556; Thu, 7 Nov 2002 12:15:21 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-2" From: Richard Huxton Organization: Archonet Ltd To: Christoph Haller , pgsql-sql@postgresql.org Subject: Re: Generating a cross tab (pivot table) Date: Thu, 7 Nov 2002 12:15:31 +0000 User-Agent: KMail/1.4.3 Cc: terry@ashtonwoodshomes.com, chaudhar@umich.edu References: <3DCA52E2.5529E893@rodos.fzk.de> In-Reply-To: <3DCA52E2.5529E893@rodos.fzk.de> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200211071215.32235.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/92 X-Sequence-Number: 10234 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= =20 results in the table-functions contrib directory in 7.3 --=20 Richard Huxton