On 4/26/2007, "Chris" <dmagick@gmail.com> wrote:
>tom wrote:
>
>> In pgsql I have to modify this a bit with 'cast (s_msgs as double
>> precision)' or 'cast(s_msgs as real)' in order to get floating point math.
>> ( cast(s_msgs as double precision)/S_msgs) and so on...
>>
>> Question: Is there a better way to get floating point math out of a set
>> of integers?
>
>Nope.
The way they treat math isn't new. cast one as real and the rest will
follow.
Any idea if it's going to be "better" or even something that can
realistically be benchmarked?