From: | Alexandre Leclerc <alexandre(dot)leclerc(at)gmail(dot)com> |
---|---|
To: | Joe Conway <mail(at)joeconway(dot)com> |
Cc: | Dawid Kuroczko <qnex42(at)gmail(dot)com>, PERFORM <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Flattening a kind of 'dynamic' table |
Date: | 2005-01-28 18:15:44 |
Message-ID: | 1dc7f0e3050128101569232b5b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Fri, 28 Jan 2005 08:34:27 -0800, Joe Conway <mail(at)joeconway(dot)com> wrote:
> Alexandre Leclerc wrote:
> >>>>>Here a normal listing of design.product_department_time:
> >>>>> product_id | department_id | req_time
> >>>>>------------+---------------+----------
> >>>>> 906 | A | 3000
> >>>>> 906 | C | 3000
> >>>>> 906 | D | 1935
> >>>>> 907 | A | 1500
> >>>>> 907 | C | 1500
> >>>>> 907 | D | 4575
> >>>>> 924 | A | 6000
> >>>>> 924 | C | 1575
>
> Sorry for jumping in on this thread so late -- I haven't been able to
> keep up with the lists lately.
>
> If I understand what you want correctly, you should be able to use
> crosstab from contrib/tablefunc:
I'm a little bit confused on how to install this contirb. I know my
contrib package is installed, but I don't know how to make it work in
postgresql. (Using 7.4.5-1mdk on Mandrake Linux.)
--
Alexandre Leclerc
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2005-01-28 18:24:37 | Re: Flattening a kind of 'dynamic' table |
Previous Message | Josh Berkus | 2005-01-28 17:48:31 | Re: Triggers During COPY |