On Tue, Mar 21, 2006 at 21:16:03 +0800,
William ZHANG <uniware@zedware.org> wrote:
>
> "Sigurdur Gunnlaugsson" <sig@fjolnet.net>
> > 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)
Don't you have to cast before the divide? I think the above will convert
the truncated result to float.
However he could do something like:
order by count(id)/cast(age as float)