converting a N rows table to a 1 row table ?

From: Arup Rakshit <aruprakshit(at)rocketmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: converting a N rows table to a 1 row table ?
Date: 2014-07-03 12:30:13
Message-ID: 1404390613.98056.YahooMailNeo@web193901.mail.sg3.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

One query is producing the below table :-

answer |  count  |  avg
  a1       3         14
  a2       2         10

How to convert this to a single row table ?

count | avg_a1  | avg_a2
  5       14       10
 
Regards,
Arup Rakshit

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pujol Mathieu 2014-07-03 12:46:41 Re: converting a N rows table to a 1 row table ?
Previous Message Dave Cramer 2014-07-03 12:03:31 Re: postgresql server version & JDBC driver version