Re: dividing integers not producing decimal fractions

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