Alexander Staubo wrote:
> 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.
>
> ---------------------------(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
