transposing data for a view - Mailing list pgsql-sql

From jeremy@wundt.psychiatry.uiowa.edu (H Jeremy Bockholt)
Subject transposing data for a view
Date
Msg-id b773797b.0110301636.5af6bd25@posting.google.com
Whole thread Raw
Responses Re: transposing data for a view  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Stéphane Chomat
Date:
Subject: Primary key with oid + name : error, which solution ?
Next
From: sharmad@goatelecom.com
Date:
Subject: Re: postgresql error