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

Re: crosstab

From: John Fabiani <johnf(at)jfcomputer(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: crosstab
Date: 2012-03-12 18:07:12
Message-ID: 4791988.YSRGgLD8kK@linux-12 (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)jfcomputer(dot)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(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-sql

In response to

Responses

pgsql-sql by date

Next:From: Pavel StehuleDate: 2012-03-12 18:11:00
Subject: Re: crosstab
Previous:From: Pavel StehuleDate: 2012-03-12 17:01:21
Subject: Re: crosstab

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group