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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org