Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: record fields as columns in reports



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(at)crankycanuck(dot)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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group