Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: "Ali Adams" <aliadams@doit4u.com>, <pgsql-sql@postgresql.org>
Subject: Re: help yourself by helping others
Date: Thu, 10 Jul 2003 09:24:36 +0100
User-Agent: KMail/1.4.3
References: <001c01c2fa9b$5b91ec80$03000000@DELLPC>
In-Reply-To: <001c01c2fa9b$5b91ec80$03000000@DELLPC>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200307100924.37218.dev@archonet.com>

On Friday 04 Apr 2003 12:10 pm, Ali Adams wrote:
> Dear All,
>
> I am new to Relational Databases and SQL and my background in ODBs is
> clouding my way to solving what seems to be a simple problem. I am sure
> many of you have met it many times.
>
> OK, I have a table as follows:
>
>
> ID Machine   Date             Withdrawals
> 1  1              01/01/2003    1101
> 2  2              01/01/2003    2101
> 3  3              01/01/2003    3101
[snip]
> And i would like to create a monthly withdrawals report as follows:
>
> Machine   Day1  Day2  Day3  Day4............ Day31

Two options - either do it in your app or write a crosstab function.

You can extract the day part of the month using:
  SELECT EXTRACT('day' FROM now());

You can find some crosstab functions in the contrib/tablefunc directory of =
the=20
source distribution (or possibly as a package if installed as binary)


--=20
  Richard Huxton