"Sigurdur Gunnlaugsson" <[EMAIL PROTECTED]> > On Mon, 2006-03-20 at 21:10, Wei Wei wrote: > > Try: > > order by count(id)/age::float
Or you can use the standard grammer: order by cast(count(id)/age as float) Regards, William ZHANG ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly