Date: Thu, 1 May 2003 07:38:02 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: Daniel <postgresql@dunajsky.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to write a sql query to get this result?
Message-ID: <20030501123802.GA16742@wolff.to>
Mail-Followup-To: Daniel <postgresql@dunajsky.com>,
	pgsql-sql@postgresql.org
References: <020601c30f92$22174ca0$0300a8c0@akssk>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <020601c30f92$22174ca0$0300a8c0@akssk>
User-Agent: Mutt/1.5.4i

On Wed, Apr 30, 2003 at 21:31:20 -0600,
  Daniel <postgresql@dunajsky.com> wrote:
> 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.

For a fixed set of rows, you can combine the queries together into
one query. If the number of rows is data dependent, then you will
want to look at the crosstab contribution as suggested in another
response.

You can do something like:

select (select total_query) as "TOTAL", (select administrator_query) as
  "Administrator", (select internet_query) as "Internet Only",
  (select filtered_query) as "Filtered Internet";
> 
> Please reply to daniel_katka@hotmail.com

Please use a reply-to header to redirect replies. (Or change your from
address.)

> 
> Thank you very much.
> 
> Daniel
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)