| From: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com>, Aasmund Midttun Godal <postgresql(at)envisity(dot)com> |
| Cc: | jeremy(at)wundt(dot)psychiatry(dot)uiowa(dot)edu, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: transposing data for a view |
| Date: | 2001-11-01 16:22:05 |
| Message-ID: | 20011101162205.3088.qmail@web20807.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 <josh(at)agliodbs(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-11-01 16:22:51 | Re: How to use BYTEA type? |
| Previous Message | Josh Berkus | 2001-11-01 16:17:00 | Re: transposing data for a view |