Dear all,
I'm sorry if this sounds stupid or have been talked about before. Suppose I have a field in my table that's called duration with type 'time without timezone'. How do I do sum on this field based on another field let say called dateofevent? SQL: SELECT SUM(duration) FROM durtable GROUP BY dateofevent; gives me: ERROR: Unable to select an aggregate function sum(time without time zone) Is this because of me still using PostgreSQL version 7.2.1 from Debian Woody? Or some other stupidity? TIA, Regards. -arief ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
