I wasn't able to get a usable answer by googling: Is there a way to create a view on a table that converts rows to columns ?[snip]
Is the above doable with a view? Any pointers will be appreciated.
Search the postgresql-sql list archives for "Arbitrary Cross-tab" for recent discussion on this.
HTH -- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
