Re: How I can get the real data type result instead of - Mailing list pgsql-general

Bruno Wolff III <bruno@wolff.to> writes:
>>> 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?

Yeah.  The :: case is OK because :: binds more tightly than /
but the second suggestion is wrong :-(

            regards, tom lane