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 [email protected] http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
