Might already be fixed...? - Mailing list pgsql-hackers

surveys=> explain select count(sys_type) as tot_sys_type,sys_type
surveys-> from op_sys
surveys-> where sys_type is not null 
surveys->   and tot_sys_type > 100
surveys-> group by sys_type
surveys-> order by tot_sys_type desc;
ERROR:  attribute 'tot_sys_type' not found

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org