How to write an query to get this result? - Mailing list pgsql-sql

From Daniel Dunajsky
Subject How to write an query to get this result?
Date
Msg-id 01be01c30f8e$d9cbf160$0300a8c0@akssk
Whole thread Raw
Responses Re: How to write an query to get this result?  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Hello,

Is there any way how to retrieve result normally displayed as:

TOTAL             268
Administrator     7
Internet Only      178
Filtered Internet  7

To be like this:

TOTAL Administrator Internet Only Filtered Internet
268        7                   178               7

That means, the rows of the first column of the first case are headers in 
the second case. Similarly, the rows of the second column are displayed as 
one row.

Please reply to daniel_katka@hotmail.com

Thank you very much.

Daniel



pgsql-sql by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: Stored Procedure Question
Next
From: "Matt Mello"
Date:
Subject: implied FROM