Skip site navigation (1) Skip section navigation (2)

Function to Pivot data

From: Ellen Cyran <ellen(at)urban(dot)csuohio(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Function to Pivot data
Date: 2002-01-31 14:17:35
Message-ID: 3.0.5.32.20020131091735.009f8c90@wolf.urban.csuohio.edu (view raw or flat)
Thread:
Lists: pgsql-general
I'm wondering if it is worth it to normalize data or not.
One problem with normalizing is that the data may require
pivoting.  Is there a pivot funtion available for postgresql?

If normalized I'll have a book table, book_author table and
an author table.  I would want to produce a table the authors
in columns instead of rows which would require pivoting.

Ellen
----



Responses

pgsql-general by date

Next:From: David.LofstrandDate: 2002-01-31 14:41:30
Subject: Re: runtime queries...
Previous:From: David.LofstrandDate: 2002-01-31 13:23:10
Subject: runtime queries...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group