| From: | John Fabiani <johnf(at)jfcomputer(dot)com> |
|---|---|
| To: | "PostgreSQL (SQL)" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | crosstab |
| Date: | 2012-03-12 16:58:03 |
| Message-ID: | 1374902.j7hCdyTH7B@linux-12 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2012-03-12 17:01:21 | Re: crosstab |
| Previous Message | rverghese | 2012-03-07 20:48:38 | Re: map row in one table with random row in another table |