Hello all,
I am trying to select the sum of a column in a view, but it doesn't give me
any data. Check this out (h_2535c_1_this is the view):
rb=> select avg_rate from h_2535c_1_this;
avg_rate
--------
40.5
51
38
37
(4 rows)
rb=> select sum(avg_rate) from h_2535c_1_this;
sum
---
(4 rows)
What's happening here? I'm using pg 6.5.3 (yes, I know it's time to
upgrade, I will when it's feasible to take down our production server) on
Linux 2.2.19 (SuSE).
Thanks,
-- Jeremy