Re: transposing data for a view

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>, 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:27:40
Message-ID: web-496672@davinci.ethosmedia.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jeff,

> 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).

Lemme try it ....

Yes, you're right. Sorry! Disregard my commentary about the second
view.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

Attachment Content-Type Size
unknown_filename text/plain 2 bytes
unknown_filename text/plain 2 bytes
unknown_filename text/plain 2 bytes

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Edward Grabczewski 2001-11-01 16:48:29 PL/pgSQL syntax for strings
Previous Message Stephan Szabo 2001-11-01 16:22:51 Re: How to use BYTEA type?