Re: record fields as columns in reports - Mailing list pgsql-sql

On 6/28/07, Reinoud van Leeuwen <reinoud.v@n.leeuwen.net> wrote:
> 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

1. See contrib/tablefunc.
2. PivotTables (OpenOffice.org or Excel).