pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
row and column transposition
2+ messages / 2 participants
[nested] [flat]

* row and column transposition
@ 2003-10-06 13:28 teknokrat <teknokrat@yahoo.com>
  2003-10-07 18:44 ` Re: row and column transposition Bruno Wolff III <bruno@wolff.to>
  0 siblings, 1 reply; 2+ messages in thread

From: teknokrat @ 2003-10-06 13:28 UTC (permalink / raw)
  To: pgsql-sql

Anyone know some sql that display a row as a set of rows with column 
name vs column value?




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: row and column transposition
  2003-10-06 13:28 row and column transposition teknokrat <teknokrat@yahoo.com>
@ 2003-10-07 18:44 ` Bruno Wolff III <bruno@wolff.to>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruno Wolff III @ 2003-10-07 18:44 UTC (permalink / raw)
  To: teknokrat <teknokrat@yahoo.com>; +Cc: pgsql-sql

On Mon, Oct 06, 2003 at 14:28:39 +0100,
  teknokrat <teknokrat@yahoo.com> wrote:
> Anyone know some sql that display a row as a set of rows with column 
> name vs column value?

contrib/tablefunc provides a crosstab function that should do what you
want.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-10-07 18:44 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-10-06 13:28 row and column transposition teknokrat <teknokrat@yahoo.com>
2003-10-07 18:44 ` Bruno Wolff III <bruno@wolff.to>

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