Received: from web20807.mail.yahoo.com (web20807.mail.yahoo.com [216.136.226.196]) by postgresql.org (8.11.3/8.11.4) with SMTP id fA1GM9P55157 for ; Thu, 1 Nov 2001 11:22:10 -0500 (EST) (envelope-from jeff_eckermann@yahoo.com) Message-ID: <20011101162205.3088.qmail@web20807.mail.yahoo.com> Received: from [65.11.165.34] by web20807.mail.yahoo.com via HTTP; Thu, 01 Nov 2001 08:22:05 PST Date: Thu, 1 Nov 2001 08:22:05 -0800 (PST) From: Jeff Eckermann Subject: Re: transposing data for a view To: Josh Berkus , Aasmund Midttun Godal Cc: jeremy@wundt.psychiatry.uiowa.edu, pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/12 X-Sequence-Number: 5398 Josh, I don't see how you got the result you quote below. My query sums the volume figures, grouping by scanid: that worked as expected (one line per scanid) on my system when I tested it (version 7.1.2, though I don't think that matters). Jeff --- Josh Berkus wrote: > Of couse, it's only *half* a solution. Your query > will result in: > > scanid A_volume B_volume C_volume > 1 34.5 > 1 55.1 > 1 12.3 > 2 11.1 > etc. > __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com