On Nov 2, 2006, at 23:54 , [EMAIL PROTECTED] 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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
