sum() is not working

[littlemaster]

Hi,
I am having database in debian os. In that sum() giving expected output.
I have changed my database from debian to lenny. In that sum() is not available. It shows the following error. Can any one help me to solve this ?

user => SELECT cmp_id ,sum(*) as count from schedules group by cmp_id;
ERROR: function sum() does not exist
LINE 1: SELECT cmp_id ,sum(*) as count from schedules group by cmp_i...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

[rski]

I don't think you can use '*' in sum function. You should use column names.

[littlemaster]

sum() not working

Yes, absolutely .. I forgot .. now it is working fine.. Any way thanks...