Date: Thu, 28 Jun 2007 16:46:15 +0200
From: Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>
To: pgsql-sql@postgresql.org
Subject: record fields as columns in reports
Message-ID: <20070628144615.GQ72343@spoetnik.xs4all.nl>
Mail-Followup-To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.13 (2006-08-11)

Hi everybody,

I have a script that runs every night and produces a list of a few error 
conditions and the number.

My manager would like it in a form where he can produce some charts in a 
spreadsheet (that's probably why he's a manager ";-).

So the table I store the errormessages in has a format like this:

CREATE TABLE repport_history
(
  rundate date,
  errordescription character varying(255),
  number bigint
) 


And I would like an output with something like:

          06/22     06/23    06/24    06/25
ERROR1     10         10       9         8
ERROR2    250        300     220       200
ERROR3      4          2       0         0


(probably in csv or something like that but that is the easy part ";-)

The problems are:
- how to create a dynamic result type? (is that possible in a stored 
procedure?)
- how to make sure that missing records are reported as 0
  (some errors might not have entries on some dates)


Has somebody ever made a generic solution for something like this? (or do 
I need a reporting tool?)


Thanks in advance,
Reinoud

-- 
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://www.xs4all.nl/~reinoud
__________________________________________________