[ADMIN] Aggregates don't work on views?

[Jeremy Buchmann]

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



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])