On 18 May 2001 13:20:25 +0100, Oliver Beddows wrote:
> Which produces the following:
> ----------------------
> label | style
> ----------------------
> Matsuri Productions | House
> Matsuri Productions | Techno
> Matsuri Productions | Trance
>
> BUT! How can I achieve the following??
> --------------------------------
> label | style1 | style2 | style3
> -------------------------------
> Matsuri Productions | House | Techno | Trance
Several times I asked if there is a SQL-way to transpone.
As I didn't get an answer I believe the answer is no.
If there was such a function it would have to take care of at least the
following:
The contents of the first column of table t has to follow the
conventions for column-names.
Columns 1..n of t have to be of the same type.
...
Perhaps it is possible to write a plpgsql-function for it,
but propably it's not worth the effort.
cu
--
Nabil Sayegh