On Nov 2, 2006, at 23:54 , rloefgren@xxxxxxxxxxxxxxx wrote:
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"...
...
How do I get fractions when dividing integers? Cast as something?
Exactly. Just as in most computer languages, incidentally: # select 1 / 2 as x; x --- 0 (1 row) # select 1 / 2::float as x; x ----- 0.5 (1 row) Alexander.
