Re: a math question

[Chris <dmagick(at)gmail(dot)com>]

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.

This is mentioned in the docs: 
http://www.postgresql.org/docs/8.2/static/functions-math.html

division (integer division truncates results)

I'm sure it's because of sql specs but someone else will throw their 
2c's in if that's wrong ;)

You only need one real or double precision field in there for that not 
to be truncated, you don't need to cast everything.

--
Postgresql & php tutorials
http://www.designmagick.com/