| From: | Tim Smith <gb10hkzo-postgres(at)yahoo(dot)co(dot)uk> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "david(dot)g(dot)johnston(at)gmail(dot)com" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Subject: | Re: A question for Postgres OLAP gurus.... |
| Date: | 2014-08-09 07:20:40 |
| Message-ID: | 1407568840.3896.YahooMailNeo@web172802.mail.ir2.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
David,
You are right of course about sample data.....
I've put some data up on Pastebin here http://pastebin.com/EtVnjiYv
As for an example of an expected result from the above :
- Order individual test results asc/desc as required, so you end up for example with for test1 as shown on paste bin under "sort result for test 1"
- Count the number of times each factor appears in an ordered position (e.g as shown by "SORT LOCATIONS FOR TEST 1", I would expect to see a+ shown as appearing twice in first position, y+ twice in second etc. etc.)
Hope this helps !
Tim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexis Bernard | 2014-08-09 09:38:52 | Duplicated IDs |
| Previous Message | Adrian Klaver | 2014-08-09 04:13:44 | Re: pgcluu |