Re: [GENERAL] Crosstab query on huge amount of values

2011-01-17 Thread Steve Litt
On Monday 17 January 2011 07:21:11 you wrote: > Am 17.01.2011 00:20, schrieb Steve Litt: > > On Sunday 16 January 2011 17:40:34 Julia Jacobson wrote: > >> Hello everybody out there using PostgreSQL, > >> > >> A table with the results of students in different exams > >> > >> student | date_of_exam |

Re: [GENERAL] Crosstab query on huge amount of values

2011-01-17 Thread Igor Neyman
> -Original Message- > From: Julia Jacobson [mailto:julia.jacob...@arcor.de] > Sent: Monday, January 17, 2011 7:21 AM > To: pgsql-general@postgresql.org > Cc: Steve Litt > Subject: Re: Crosstab query on huge amount of values > > Am 17.01.2011 00:20, schrieb Steve Litt: > > On Sunday 16

Re: [GENERAL] Crosstab query on huge amount of values

2011-01-17 Thread Julia Jacobson
Am 17.01.2011 00:20, schrieb Steve Litt: On Sunday 16 January 2011 17:40:34 Julia Jacobson wrote: Hello everybody out there using PostgreSQL, A table with the results of students in different exams student | date_of_exam | grade -- Peter | 2010-09-09 | 2 Tom

Re: [GENERAL] Crosstab query on huge amount of values

2011-01-16 Thread Steve Litt
On Sunday 16 January 2011 17:40:34 Julia Jacobson wrote: > Hello everybody out there using PostgreSQL, > > A table with the results of students in different exams > > student | date_of_exam | grade > -- > Peter | 2010-09-09 | 2 > Tom | 2010-09-09 | 1 > Andy

[GENERAL] Crosstab query on huge amount of values

2011-01-16 Thread Julia Jacobson
Hello everybody out there using PostgreSQL, A table with the results of students in different exams student | date_of_exam | grade -- Peter | 2010-09-09 | 2 Tom | 2010-09-09 | 1 Andy| 2010-09-21 | 3 Tom | 2010-09-21 | 4 Peter | 2010-09-21 | 1