From: Daniel <postgresql@dunajsky.com>
To: pgsql-sql@postgresql.org
Subject: How to write a sql query to get this result?
Date: Wed, 30 Apr 2003 21:31:20 -0600
Message-ID: <020601c30f92$22174ca0$0300a8c0@akssk> (raw)
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
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: postgresql@dunajsky.com
Subject: Re: How to write a sql query to get this result?
In-Reply-To: <020601c30f92$22174ca0$0300a8c0@akssk>
* 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