Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 2538E29F0D5 for ; Mon, 12 Mar 2012 13:58:22 -0300 (ADT) Received: from [76.14.161.106] (helo=newserver.jfcomputer.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S78Zg-000595-VC for pgsql-sql@postgresql.org; Mon, 12 Mar 2012 16:58:21 +0000 Received: from localhost (unknown [127.0.0.1]) by newserver.jfcomputer.com (Postfix) with ESMTP id CBC5AFC29 for ; Mon, 12 Mar 2012 16:58:04 +0000 (UTC) X-Virus-Scanned: amavisd-new at site Received: from newserver.jfcomputer.com ([127.0.0.1]) by localhost (linux-jfp8.site [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id DPtqUc43T+wR for ; Mon, 12 Mar 2012 09:58:03 -0700 (PDT) Received: from linux-12.localnet (unknown [192.168.1.254]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: johnf@jfcomputer.com) by newserver.jfcomputer.com (Postfix) with ESMTPSA id DC0D15931 for ; Mon, 12 Mar 2012 09:58:03 -0700 (PDT) From: John Fabiani To: "PostgreSQL (SQL)" Subject: crosstab Date: Mon, 12 Mar 2012 09:58:03 -0700 Message-ID: <1374902.j7hCdyTH7B@linux-12> User-Agent: KMail/4.7.2 (Linux/3.1.9-1.4-desktop; KDE/4.7.2; x86_64; ; ) MIME-Version: 1.0 Content-Transfer-Encoding: 7Bit Content-Type: text/plain; charset="us-ascii" X-Host-Lookup-Failed: Reverse DNS lookup failed for 76.14.161.106 (failed) X-Pg-Spam-Score: 1.6 (+) X-Archive-Number: 201203/37 X-Sequence-Number: 36432 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