Re: Turning column into row - Mailing list pgsql-sql

From Tille, Andreas
Subject Re: Turning column into row
Date
Msg-id Pine.LNX.4.44.0205221202530.8932-100000@wr-linux02.rki.ivbb.bund.de
Whole thread Raw
In response to Re: Turning column into row  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-sql
On Wed, 22 May 2002, Oliver Elphick wrote:

> Use Perl?
Well, I just started to write a Python script, but it showes to
make some effort to accomplish the same I did in a simple shell script
before.  I use an intermediate output using some PostgreSQL functions
and CASE statements to get a raw ASCII output which was formatted
quite nicely for this purpose by a single SELECT statement into
a proper sized table.  It would cost a fair amount of Perl/Python/Whatever
code to do the same.

I know that this is a problem which is quite hard in plain SQL but
I've thought I could do some magic using plpgsql-FUNCTIONS but I
failed to solve it.

Kind regards
        Andreas.


pgsql-sql by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Turning column into row
Next
From: Gabriel Dovalo Carril
Date:
Subject: Re: Turning column into row