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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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