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/