Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: "Daniel Dunajsky" <daniel@dunajsky.com>,
	<pgsql-sql@postgresql.org>
Subject: Re: How to write an query to get this result?
Date: Fri, 2 May 2003 09:48:35 +0100
User-Agent: KMail/1.4.3
References: <01be01c30f8e$d9cbf160$0300a8c0@akssk>
In-Reply-To: <01be01c30f8e$d9cbf160$0300a8c0@akssk>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200305020948.36607.dev@archonet.com>

On Thursday 01 May 2003 4:07 am, Daniel Dunajsky 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.

There are some crosstab-style functions in the contrib directory in source.=
=20
Can't remember where, sorry. Look for something like "cross-tab" or try the=
=20
table-function examples.

--=20
  Richard Huxton