Re: a math question

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/