Re: integer instead of 'double precision'? - Mailing list pgsql-general

From Tom Lane
Subject Re: integer instead of 'double precision'?
Date
Msg-id 11955.1315581161@sss.pgh.pa.us
Whole thread Raw
In response to integer instead of 'double precision'?  (Henry Drexler <alonup8tb@gmail.com>)
Responses Re: integer instead of 'double precision'?  (Henry Drexler <alonup8tb@gmail.com>)
List pgsql-general
Henry Drexler <alonup8tb@gmail.com> writes:
> [ "1/3" yields zero ]

Yeah, it's an integer division.

> I thought perhaps I could cast it as double precision as noted on
> http://www.postgresql.org/docs/8.3/interactive/sql-expressions.html
> though doing the following:
> float8(1/3)

That's casting the result of the division to float, which is way too
late.  You need to cast one or both inputs to non-integer, for instance

    1.0/3
    1/(3::float8)

etc etc.

            regards, tom lane

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: integer instead of 'double precision'?
Next
From: Carlos Mennens
Date:
Subject: PostgreSQL Upgrade Procedure