From: | Balázs Klein <bklein(at)t-online(dot)hu> |
---|---|
To: | "'jr'" <jorg(dot)raskowski(at)tailorware(dot)org(dot)uk>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: dynamic crosstab |
Date: | 2008-02-14 07:43:29 |
Message-ID: | 20080214074334.1E867BDCDF@mail00d.mail.t-online.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)raskowski(at)tailorware(dot)org(dot)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(at)tailorware(dot)org(dot)uk)
From | Date | Subject | |
---|---|---|---|
Next Message | Balázs Klein | 2008-02-14 08:04:09 | Re: dynamic crosstab |
Previous Message | First NameBipllab Roy | 2008-02-14 07:35:15 | installation problem |