Postgres Pro
Downloads
Home   >   mailing lists

converting a N rows table to a 1 row table ? - Mailing list pgsql-general

From Arup Rakshit
Subject converting a N rows table to a 1 row table ?
Date
Msg-id 1404390613.98056.YahooMailNeo@web193901.mail.sg3.yahoo.com
Whole thread Raw
Responses Re: converting a N rows table to a 1 row table ?  (Pujol Mathieu <mathieu.pujol@realfusio.com>)
Re: converting a N rows table to a 1 row table ?  (Chris Curvey <chris@chriscurvey.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Dave Cramer
Date:
Subject: Re: postgresql server version & JDBC driver version
Next
From: Pujol Mathieu
Date:
Subject: Re: converting a N rows table to a 1 row table ?