I'm trying to produce a decimal fraction by dividing integer fields
like this fragment of the query:
...((cntoh0.count + cntoh1.count)/ttl_deptcat.ttlcount) as "Ratio"...
I get this output
dept_cat | cnt_oh_0 | cnt_oh_1 | sum_oh_0+1 | ttl_count | Ratio
------------+----------+----------+------------+-----------+-------
101500 | 116 | 18 | 134 | 238 | 0
101800 | 409 | 46 | 455 | 467 | 0
101900 | 197 | 1 | 198| 198 | 1
Why does "Ratio" display as 0, rather than the proper decimal fraction?
All of the *oh* fields are integers and ttl_count is a bigint. I've
tried wrapping all the integer fields with round(<fieldname>, 3) and I
do get the proper number of zeros to the right of the decimal on the
*oh* fields but not on the "Ratio" field. How do I get fractions when
dividing integers? Cast as something? (I suppose this is going to be
obvious, after-the-fact.)
Thanks for any tips,
r
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
