X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 26229475A45
	for <pgsql-sql@postgresql.org>; Wed, 30 Apr 2003 23:14:30 -0400 (EDT)
Received: from priv-edtnes44.telusplanet.net (outbound05.telus.net
	[199.185.220.224])
	by postgresql.org (Postfix) with ESMTP id DE589475A45
	for <pgsql-sql@postgresql.org>; Wed, 30 Apr 2003 23:13:58 -0400 (EDT)
Received: from akssk ([137.186.229.180]) by priv-edtnes44.telusplanet.net
	(InterMail vM.5.01.05.17 201-253-122-126-117-20021021) with SMTP
	id <20030501031403.YPHA3906.priv-edtnes44.telusplanet.net@akssk>
	for <pgsql-sql@postgresql.org>; Wed, 30 Apr 2003 21:14:03 -0600
Message-ID: <01be01c30f8e$d9cbf160$0300a8c0@akssk>
From: "Daniel Dunajsky" <daniel@dunajsky.com>
To: <pgsql-sql@postgresql.org>
Subject: How to write an query to get this result?
Date: Wed, 30 Apr 2003 21:07:50 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Spam-Status: No, hits=-1.6 required=5.0
	tests=BAYES_30
	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200305/10
X-Sequence-Number: 13175

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