Function to Pivot data - Mailing list pgsql-general

From Ellen Cyran
Subject Function to Pivot data
Date
Msg-id 3.0.5.32.20020131091735.009f8c90@wolf.urban.csuohio.edu
Whole thread Raw
List 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
----



pgsql-general by date:

Previous
From: David.Lofstrand@surgical-science.com
Date:
Subject: runtime queries...
Next
From: tomasz konefal
Date:
Subject: transactions outside the database...