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

From Andrew Sullivan
Subject Re: record fields as columns in reports
Date
Msg-id 20070628152151.GD29684@phlogiston.dyndns.org
Whole thread Raw
In response to record fields as columns in reports  (Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>)
List pgsql-sql
On Thu, Jun 28, 2007 at 04:46:15PM +0200, Reinoud van Leeuwen wrote:
> 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

I think this should be possible with the "crosstab" functionality
delivered in Joe Conway's tablefunc package, in contrib/.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what 
you told them to.  That actually seems sort of quaint now.    --J.D. Baldwin


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
Next
From: "Rodrigo De León"
Date:
Subject: Re: record fields as columns in reports