Postgres Pro
Downloads
Home   >   mailing lists

Re: reporting and transposition - Mailing list pgsql-novice

From Didier Gasser-Morlay
Subject Re: reporting and transposition
Date
Msg-id 608b66ce1002181353ta495652hd976ab11764a65ba@mail.gmail.com
Whole thread Raw
In response to Re: reporting and transposition  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view
I'll have a look,

thanks for the pointer

Didier

On 18 February 2010 16:25, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Didier Gasser-Morlay <didiergm@gmail.com> writes:
> I have got several reports to write which involve some sort of
> transposition.

I think what you're looking for is "crosstab".  Look into
contrib/tablefunc for some functions that will help.

                       regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: reporting and transposition
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: check_postgres