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