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 <jo...@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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
