Re: integer instead of 'double precision'? - Mailing list pgsql-general

From Scott Ribe
Subject Re: integer instead of 'double precision'?
Date
Msg-id B3943E46-A027-4A83-A286-B06CF73B7890@elevated-dev.com
Whole thread Raw
In response to integer instead of 'double precision'?  (Henry Drexler <alonup8tb@gmail.com>)
List pgsql-general
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
precisionresult? 

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@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





pgsql-general by date:

Previous
From: Henry Drexler
Date:
Subject: Re: integer instead of 'double precision'?
Next
From: Steve Crawford
Date:
Subject: Re: PostgreSQL Upgrade Procedure