On Nov 2, 2006, at 23:54 , rloefgren(at)forethought(dot)net 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.