agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Jan Ostrochovsky <ostrochovsky@mobiletech.sk>
To: dahd101+hm3ufk@guerrillamail.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Formatting query result like a calendar
Date: Fri, 4 Apr 2014 16:43:52 +0200 (CEST)
Message-ID: <264572247.1712456.1396622632842.JavaMail.root@mobiletech.sk> (raw)
In-Reply-To: <779cbb18a1d78ad415d8faf6ba1dc9bbcd39@guerrillamail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

Hi Jen, 


what you need is called transposition - look for crosstab (part of tablefunc). 


http://www.postgresql.org/docs/9.3/static/tablefunc.html 


Jano Ostrochovsky 

----- Original Message -----


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 

view thread (2+ messages)

Message-ID: <264572247.1712456.1396622632842.JavaMail.root@mobiletech.sk>
Permalink:  ../264572247.1712456.1396622632842.JavaMail.root@mobiletech.sk/
Also on:    postgresql.org/message-id/264572247.1712456.1396622632842.JavaMail.root@mobiletech.sk

reply

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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ostrochovsky@mobiletech.sk, dahd101+hm3ufk@guerrillamail.com
  Subject: Re: Formatting query result like a calendar
  In-Reply-To: <264572247.1712456.1396622632842.JavaMail.root@mobiletech.sk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox