Re: Formatting query result like a calendar

From: dahd101+hm3ufk@guerrillamail.com
To: pgsql-sql@postgresql.org
Sent: Friday, April 4, 2014 2:34:07 PM
Subject: [SQL] Formatting query result like a calendar

Hi,

I have a query result that comes out as follows (this is an excerpt, the whole thing shows a whole month):

Date   ID    Day
31/03   1    Mon
01/04   0    Tue
02/04   1    Wed
03/04   1    Thu
04/04   0    Fri
07/04   1    Mon
08/04   0    Tue
09/04   1    Wed
10/04   1    Thu
11/04   0    Fri

I need it in the format:

Date      Mon   Tue   Wed  Thu  Fri
31/03      1     0     1    1    0
07/04      1     0     1    1    0


Any ideas?

Thanks!
Jen





----
Sent using GuerrillMail.com
Block or report abuse: https://www.guerrillamail.com/abuse/?a=UUZnFAFNUKUZqB6742oYYBHUXMbe3cVX





--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql