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
workaroundfor anybody not currently owning SPSS.
Thanks.
SWK
-----Original Message-----
From: jr [mailto:jorg.raskowski@tailorware.org.uk]
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@tailorware.org.uk)