Date index for Jan 2002

Hi List,

i think i postet a similar error before in: >>[achievo] Possible Bug in 
SQL-Query<<
it deals with the problem of postgre to handel the SUM(x) in the SELECT 
statemennt.
in postgre you must have every SELECTed field in the GROUP statement 
when you want to use SUM(x) (not very comfortable :( )

here is the errormessage from pgsql

>psql -e achievo
[...]
achievo=# SELECT sum(time) as time,
             activitydate, hours.userid, employee.name
          FROM hours, employee
          WHERE hours.userid ='t.henle'
             AND activitydate >= '2002-01-01'
             AND activitydate <= '2002-01-08'
             AND hours.userid = employee.userid
          GROUP BY hours.userid, activitydate;
[...]
ERROR:  Attribute employee.name must be GROUPed or used in an aggregate 
function
achievo=# SELECT sum(time) as time,
             activitydate, hours.userid, employee.name
          FROM hours, employee
          WHERE hours.userid ='t.henle'
             AND activitydate >= '2002-01-01'
             AND activitydate <= '2002-01-08'
             AND hours.userid = employee.userid
             GROUP BY hours.userid, activitydate, employee.name;
[...]                                             ^^^^^^^^^^^^^
WORKS!

i don't know wether this changes something in the programm logic or not!
but if it don't you can fix this easiely.

cu (mit freundlichen Grüßen)

-Tobias Henle