Re: Crosstable query

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: "Dok, D(dot) van" <d(dot)vandok(at)ecn(dot)nl>
Cc: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Crosstable query
Date: 2003-12-22 22:32:32
Message-ID: BB7424EA-34CE-11D8-AB87-000A95C88220@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Dec 19, 2003, at 8:41 AM, Dok, D. van wrote:
> MS Access has a 'TRANSFORM' function to do this, which transposes the
> data
> along a pivot.

You'll probably want to look at Joe Conway's tablefunc. It's in
contrib. It's included in 7.4; I'm not sure about 7.3.4, but you can
add it if it's not.

Hope this helps.

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-12-22 23:07:02 Re: SQL Optimization
Previous Message Dave Cramer 2003-12-22 19:32:19 Re: Insert Row to ResultSet