From: jeremy@wundt.psychiatry.uiowa.edu
To: pgsql-sql@postgresql.org
Subject: transposing data for a view
Date: 30 Oct 2001 16:36:17 -0800
Message-ID: <b773797b.0110301636.5af6bd25@posting.google.com> (raw)
I have a generalized table:
scanid | region | volume
-------------------------
1 A 34.4
1 B 32.1
1 C 29.1
2 A 32.4
2 B 33.2
2 C 35.6
.
.
.
I want to create a flattened out view that looks like the following:
scanid | A_volume | B_volume | C_volume
----------------------------------------
1 34.4 32.1 29.1
2 32.4 33.2 35.6
.
.
.
How do I correctly/efficiently construct a psql query to
pivot/transpose the data? I am using postgreSQL version 7.0.x
thanks,
Jeremy
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: jeremy@wundt.psychiatry.uiowa.edu
Subject: Re: transposing data for a view
In-Reply-To: <b773797b.0110301636.5af6bd25@posting.google.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