Search Postgresql Archives
converting a N rows table to a 1 row table ?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
: "
pgsql-general@xxxxxxxxxxxxxx
" <
pgsql-general@xxxxxxxxxxxxxx
>
Subject
: converting a N rows table to a 1 row table ?
From
: Arup Rakshit <
aruprakshit@xxxxxxxxxxxxxx
>
Date
: Thu, 3 Jul 2014 20:30:13 +0800
Reply-to
: Arup Rakshit <
aruprakshit@xxxxxxxxxxxxxx
>
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
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: converting a N rows table to a 1 row table ?
From:
Chris Curvey
Re: converting a N rows table to a 1 row table ?
From:
Pujol Mathieu
Prev by Date:
Re: postgresql server version & JDBC driver version
Next by Date:
Re: converting a N rows table to a 1 row table ?
Previous by thread:
Failed to build transaction for opengeo-server
Next by thread:
Re: converting a N rows table to a 1 row table ?
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
