Re: Generating a cross tab (pivot table)

From: Richard Huxton <dev(at)archonet(dot)com>
To: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, pgsql-sql(at)postgresql(dot)org
Cc: terry(at)ashtonwoodshomes(dot)com, chaudhar(at)umich(dot)edu
Subject: Re: Generating a cross tab (pivot table)
Date: 2002-11-07 12:15:31
Message-ID: 200211071215.32235.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Nekta Katz 2002-11-07 12:22:26 cast lo to oid
Previous Message Christoph Haller 2002-11-07 11:47:46 Generating a cross tab (pivot table)