Hi, Yes I know that SPSS can do this - in fact that is the only way I could solve this so far, but that is a very expensive workaround for anybody not currently owning SPSS. Thanks. SWK -----Original Message----- From: jr [mailto:jorg.raskowski@xxxxxxxxxxxxxxxxx] Sent: Wednesday, February 13, 2008 1:31 PM To: SunWuKung Subject: Re: dynamic crosstab hi SWK SunWuKung wrote: > I know that most db people don't care much about pivot/crosstab in the > db but imagine this situation: > I am storing questionnaire results on people. Since the questionnaires > are created by users I have no other way than using an EAV model like are you using the right tool for this task? > Moreover my users can't do anything with this dataformat - they need > to pivot it offline anyway, which is not easy (Excel cant do it, > Access cant do it, numberGo cant do it for different reasons). back at college we used SPSS - the Statistical Package for Social Sciences. > Please let me know if you know of a good db based way to create a > dynamic crosstab in Postgres - or why there shouldn't be one. to be honest I don't; I think that a specialised product (such as SPSS) will solve both problems in one stroke. -- regards, jr. (jr@xxxxxxxxxxxxxxxxx) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
