Re: How I can get the real data type result instead of

On Tue, Mar 21, 2006 at 21:16:03 +0800,
  William ZHANG  wrote:
> 
> "Sigurdur Gunnlaugsson" 
> > 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)