Re: dividing integers not producing decimal fractions

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