From: John Fabiani <johnf@jfcomputer.com>
To: pgsql-sql@postgresql.org
Subject: Re: crosstab
Date: Mon, 12 Mar 2012 11:07:12 -0700
Message-ID: <4791988.YSRGgLD8kK@linux-12> (raw)
In-Reply-To: <CAFj8pRCNAMhkkvqjrJfHmhHjGhBhza1bqeNL+ykSfqJUkxw3tw@mail.gmail.com>
References: <1374902.j7hCdyTH7B@linux-12>
<CAFj8pRCNAMhkkvqjrJfHmhHjGhBhza1bqeNL+ykSfqJUkxw3tw@mail.gmail.com>
select *
from crosstab('select item_number::text, week_of::date, planned_demand::text
from holding_table order by 1,2')
as ct(row_name text, week_of date, planned text)
The above does not work. What am I doing wrong?
Johnf
On Monday, March 12, 2012 06:01:21 PM Pavel Stehule wrote:
> Hello
>
> maybe this article helps
> http://stackoverflow.com/questions/3002499/postgresql-crosstab-query
>
> there are more ways
>
> Regards
>
> Pavel Stehule
>
> 2012/3/12 John Fabiani <johnf@jfcomputer.com>:
> > Hi,
> > I don't know if it because I'm as sick as dog or I'm just a plain idiot
> > - most likely a little of both.
> >
> > Here is my table
> >
> > week_of date,
> > item_number text,
> > planned_demand integer.
> >
> > I have
> > week_of item_number planned
> > 2012-02-12 00005 200
> > 2012-02-19 00005 -30
> > 2012-02-26 00005 -16
> >
> > I want to see
> >
> > item_number 2012-02-12 2012-02-19 2012-02-26
> > 00005 200 -30 -16
> >
> > I actually have added fields but that should get me started.
> >
> > Thanks for help from an old man with a very bad cold.
> >
> > Johnf
> >
> > --
> > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-sql
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: johnf@jfcomputer.com
Subject: Re: crosstab
In-Reply-To: <4791988.YSRGgLD8kK@linux-12>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox