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