Alexander Staubo wrote: > 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. > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq You're right (I dug around in the documentation and edjoocated myself). However: sales=# select 1/2; ?column? ---------- 0 (1 row) and: sales=# select 1/2::float; ?column? ---------- 0.5 (1 row) but: sales=# select 1/2*4::float; ?column? ---------- 0 (1 row) or: sales=# select (1/2)*4::float; ?column? ---------- 0 (1 row) or try: sales=# select (1/2)* 4::numeric(6,3); ?column? ---------- 0.000 (1 row) I'll just avoid this next time by not throwing "integer" around so quickly. (At least until I become something of a postgres obi-wan...) thanks, r
