From: William Leeke <wleeke@ix.netcom.com>
To: pgsql-sql@postgresql.org
Subject: SQL equiv to MS-Access Transform
Date: Fri, 18 Sep 1998 01:39:21 -0500
Message-ID: <36020019.F0178A9D@ix.netcom.com> (raw)
ver: postgresql-6.2.1-7
OK, Ive been looking for solution for about 8 hours straight now and my
head hurts.
Is it possible to do this ...
TRANSFORM Statement Examples
SQL statement Description
PARAMETERS [Sales for which year?] LONG;
TRANSFORM Sum([Order Details].Quantity * ([Order Details].
[Unit Price] - ([Order Details].Discount / 100) * [Order Details].
[Unit Price])) AS Sales
SELECT [Product Name]
FROM Orders INNER JOIN
(Products INNER JOIN [Order Details]
ON Products.[Product ID] = [Order Details].[Product ID]) ON
Orders.[Order ID] = [Order Details].[Order ID]
WHERE DatePart("yyyy", [Order Date]) = [Sales for which year?]
GROUP BY [Product Name]
ORDER BY [Product Name]
PIVOT DatePart("m", [Order Date]);
Creates a crosstab query that shows product sales by month for a
user-specified year. The months are displayed from left to right
(pivoted) as columns, and the product names are displayed from top to
bottom as rows.
...with in postgres?
If this is a sore subject, I appologize ahead of time.
If this is referenced in a FAQ somewhere, please point the way.
Pivoting time data from rows to columns *seems to be a common if
non-intuitive thing to do with a database. :)
thanks,
wbl
--
"If you're not supposed to eat animals,
why are they made of meat?" :)
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: wleeke@ix.netcom.com
Subject: Re: SQL equiv to MS-Access Transform
In-Reply-To: <36020019.F0178A9D@ix.netcom.com>
References: <36020019.F0178A9D@ix.netcom.com>
* 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