Re: integer instead of 'double precision'? - Mailing 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