On Sep 9, 2011, at 8:42 AM, Henry Drexler wrote:
> any ideas on how to get this type of a manufactured column (not sure the right term for it) to show the double precision result?
Use floating point types in the calculation to begin with.
1.0/3.0
1::float8 / 3::float8
float8(1) / float8(3)
1.0/3
1/3.0
1::float8 / 3
...
--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice