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?
Date: Thu, 1 May 2003 07:38:02 -0500
Message-ID: <20030501123802.GA16742@wolff.to> (raw)
In-Reply-To: <020601c30f92$22174ca0$0300a8c0@akssk>
References: <020601c30f92$22174ca0$0300a8c0@akssk>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, postgresql@dunajsky.com
Subject: Re: How to write a sql query to get this result?
In-Reply-To: <20030501123802.GA16742@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox